Export Dataset to Excel from ASP.NET

Export Dataset to Excel from ASP.NET Screenshot Export Dataset to Excel from ASP.

Developer:   Morrison Schwartz, Inc.
      software by Morrison Schwartz, Inc. →
Price:  0.00
License:   Freeware
File size:   0K
Language:   
OS:   Windows Vista (?)
Rating:   0 /5 (0 votes)

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  

Export Dataset to Excel from ASP.NET screenshot


Download Export Dataset to Excel from ASP.NET

 Download Export Dataset to Excel from ASP.NET


Similar software

Export Dataset to Excel from ASP.NET Export Dataset to Excel from ASP.NET
Morrison Schwartz, Inc.

Export Dataset to Excel from ASP.

Export Query to Excel for SQL Server 1.08.00 Export Query to Excel for SQL Server 1.08.00
OmBelt Solutions

Export Query to Excel for Microsoft SQL Server will help you save results of a query execution to Excel spreadsheet.

xPort Tools for .NET 2.8.1 xPort Tools for .NET 2.8.1
Val Mazur

xPort Tools for .

MSSQL-to-Excel 1.5 MSSQL-to-Excel 1.5
Intelligent Converters

MSSQL-to-Excel is an application to publish Microsoft SQL databases as Microsoft Excel spreadsheets.

Oracle to Excel 1.3 Oracle to Excel 1.3
Intelligent Converters

Oracle-to-Excel is a program to convert Oracle databases into MS Excel spreadsheet.

SQL Converter for Excel 2.0 SQL Converter for Excel 2.0
Peachtree Communication Systems

SQL Converter 2 for Excel is an easy-to-use tool that quickly converts your worksheets to real SQL database tables.

Export Query to Excel for SQL Server Professional 1.02.00 Export Query to Excel for SQL Server Professional 1.02.00
OmBelt Solutions

Export Query to Excel for Microsoft SQL Server will help you save results of a query execution to Excel spreadsheet.

Aspose.Excel 3.5 Aspose.Excel 3.5
Aspose Pty Ltd

Aspose.

Categorizing Data for Excel 1.0 Categorizing Data for Excel 1.0
Model Advisor

If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then Categorizing Data for Excel is the solution.

Recovery for Excel 6.0.19635 Recovery for Excel 6.0.19635
Recoveronix Ltd

Recovery for Excel is a program that will fix corrupted Microsoft Excel spreadsheet files (.