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.

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

xPort Tools for .

Pushpin Tool 2.4 Pushpin Tool 2.4
Winwaed Software Technology LLC

Pushpin Tool v2.

Excel MS Access Import, Export & Convert Software 1.1 Excel MS Access Import, Export & Convert Software 1.1
sobolsoft

Excel MS Access Import, Export & Convert Software is a Excel Add-in will allow you to use Excel for importing and exporting tables to and from your Access database.

SMExport suite for Delphi/CBuilder 4.68 SMExport suite for Delphi/CBuilder 4.68
Scalabium Software

SMExport for Delphi/CBuilder is a component suite for data export from TDBGrid/TDataSet (with BDE or without) into: - XLS (Excel spreadsheet without OLE) - MS Excel (using OLE) - MS Word (using OLE) - MS Access (using DAO 3.

Excel Export To XML Software 1.1 Excel Export To XML Software 1.1
Sobolsoft

Excel Export To XML Software quickly export selected Excel tables to XML.

Excel OCX 2.4 Excel OCX 2.4
SkySof Software Inc.

Excel OCX is a powerful ActiveX Control with more than a hundred useful functions to assist in data exchanging between Excel and Visual Basic and much more using COM technology! Included in the download is a sample Visual Basic project which demonstrates the power of Excel OCX.

Excel to MySQL Import, Export & Convert 1.1 Excel to MySQL Import, Export & Convert 1.1
Sobolsoft

Do a conversion from Excel to MySQL or MySQL to Excel free of MySQL query knowledge.

Export Table to Excel for MS SQL Server 1.00.00 Export Table to Excel for MS SQL Server 1.00.00
OmBelt Solutions

Export Table to Excel for MS SQL Server program will allow you to export data rows from selected table to Excel spreadsheets.

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.