Export Dataset to Excel from ASP.NET
Export Dataset to Excel from ASP.
|
0.00 
Freeware
0K
Windows Vista 
Export Dataset to Excel from ASP.NET demonstrates exporting a DataSet to Excel in ASP.NET, without using the Excel object model. We did not want to install Office on the server just to get the ability to create an Excel spreadsheet.
What's so special about this? Well, of all of the online samples we could find, none of them had any way to create multiple Worksheet tabs within the spreadsheet without using the Excel object model. Trying to fit multiple tables in a single Worksheet causes several interesting and unnacceptable formatting problems, not to mention difficulties in finding precisely the data that was desired.
This is accomplished by building and returning an XML file which is created programmatically, in an Excel-readable format. Once this file is built, it is written directly to the Response stream, and the Response ContentType and appropriate HTTP headers are set to indicate that the page's output is an Excel spreadsheet.
The resulting spreadsheet will contain a seperate Worksheet for every table in the Dataset. The Worksheet will be named the same as the corresponding Table.
This demonstration project returns all of the data in all tables of the Northwind database on the local server.
Export Dataset to Excel from ASP NET Download
tags
asp net excel spreadsheet object model the data the response excel object using the excel from from asp without using export dataset the excel
Download Export Dataset to Excel from ASP.NET
Download Export Dataset to Excel from ASP.NET
Authors software
Google 2.0.1
Morrison Schwartz, Inc.
Google Plugin allows the developer to search Google from Visual Studio.
Add Copyright Notice Plugin
Morrison Schwartz, Inc.
This project is a SharpTools plugin which helps the developer to specify a custom header that can be added to each code file in the current VS.
Collection Builder Plugin
Morrison Schwartz, Inc.
Collection Builder Plugin is a SharpTools plugin which allows the developer to create a strongly-typed collection from any class in the current Visual Studio project.
Zip Project Plugin
Morrison Schwartz, Inc.
Zip Project Plugin helps the developer to create a ZIP archive of project files from within the VS.
API to .NET Mapping Plugin
Morrison Schwartz, Inc.
Similar software
Export Dataset to Excel from ASP.NET
Morrison Schwartz, Inc.
Export Dataset to Excel from ASP.
Complete Excel Names 1.1
Afalina Co., Ltd.
Complete Excel Names is a free COM add-in that allows you to set the width of the Name Box in Microsoft Excel.
EZ-R Excel 0.94 Beta
EZ-R Stats Software
This is a stand-alone product for the analysis of data in Excel worksheets.
Excel Utility 7.3
Likeoffice.com
Likeoffice Excel Utility is created to ease your work using Microsoft Excel.
Excel Compare by Mousesoft 1.00
Mousesoft
MEC is an Excel Addin that compares two Excel workbooks for changes.
Excel Website Pro 1.0
ZANTU.com
Excel Website Pro produces websites from Excel at the click of a button.
Excel Viewer 2003 1.0
Microsoft
With Excel Viewer 2003, you can open, view, and print Excel workbooks, even if you don't have Excel installed.
Excel Cubic Spline Function Spreadsheet 1.01
SRS1 Software
This is a vba cubic_spline function for Microsoft Excel along with a utility to import the cubic_spline function into any Excel workbook.
Excel Bulk Mailer 3.00
Martin Groesbeek
Excel Bulk Mailer is an excel based 'Mass Mailer'.
Ms Word Excel Cracker 2.0
FDRLab Data Recovery Centre
Excel Cracker is a useful application designed to recover lost or forgotten passwords for .
Other software in this category
File Analyzer 1.6 12.10.2002
Vadim Tarasov
File Analyzer is a software application that can identify the format of a file, with what it was compiled, encrypted, packed, etc.
Snap 1.1
Fritz
This program is a multiplatform (9x,ME,NT4) Task/Window manager and MORE.
FileType v1.26
X-Fixer
FileType is intended to give the "first-look" file type information without any futher details.
CodeSnip 1.0
Dacris Software
CodeSnip helps you to increase your daily coding efficiency.
ExamDiff 1.6m
PrestoSoft
ExamDiff is a useful utility for visual file comparison.
RSS