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


Authors software

Google 2.0.1 Google 2.0.1
Morrison Schwartz, Inc.

Google Plugin allows the developer to search Google from Visual Studio.

Add Copyright Notice Plugin 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 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 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 API to .NET Mapping Plugin
Morrison Schwartz, Inc.

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.

EZ-R Excel 0.94 Beta EZ-R Excel 0.94 Beta
EZ-R Stats Software

This is a stand-alone product for the analysis of data in Excel worksheets.

XLCalendar 1.4 XLCalendar 1.4
LJZsoft Corporation

XLCalendar is a calendar generator for Microsoft Excel that will output calendars in Microsoft Excel spreadsheet format.

nn_Solve 1.1 nn_Solve 1.1
XLPert Enterprise

nn_Solve is a neural network model built with MS Excel.

Excel Cubic Spline Function Spreadsheet 1.01 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.

GemBox.Spreadsheet Free 2.7 GemBox.Spreadsheet Free 2.7
GemBox Software

GemBox.

StockWatch 8.0 StockWatch 8.0
BREAKTRU SOFTWARE

StockWatch is built as an Excel spreadsheet will help you create a portfolio of your past and present stock holdings.

jWorkbook 2.0 jWorkbook 2.0
St James Software

jWorkBook: Get Database information directly into your spreadsheet Now a quick way to get the information that is currently in your system databases directly into your spreadsheet.

Excel Automated Grader (Marker) 1.3.07 Excel Automated Grader (Marker) 1.3.07
ExcelGrader.com - Thomas G. Hill

Excel Automated Grader is an automated grader/marker for use by instructors in Microsoft Excel and Microsoft Office application courses.

OLAP Reporting Tool for Excel 3 OLAP Reporting Tool for Excel 3
kalmstrom.nu

OLAP Reporting Tool for Excel is a very good tool for browsing through data.

Other software in this category

File Analyzer 1.6 12.10.2002 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 Snap 1.1
Fritz

This program is a multiplatform (9x,ME,NT4) Task/Window manager and MORE.

FileType v1.26 FileType v1.26
X-Fixer

FileType is intended to give the "first-look" file type information without any futher details.

CodeSnip 1.0 CodeSnip 1.0
Dacris Software

CodeSnip helps you to increase your daily coding efficiency.

ExamDiff 1.6m ExamDiff 1.6m
PrestoSoft

ExamDiff is a useful utility for visual file comparison.