The Gridview to Excel Export Tool allows you to export data from your
ASP.NET Web Site and .NET Windows Forms into XML
Excel 2003 or XLSX Excel 2007/2010 format in a matter of seconds.
Overview
It consists of a dll you reference from your Visual Studio ASP.NET/.NET Project.
It allows you to export data from Sqldatasource, Dataview, Sql datareader,
Datatable, Sqldatareader, Oledbdatasource, Oledbdatareader, Objectdatasource to 2003/2007/2010 XML/XLSX Excel Sheets with a few lines of codes.
It does not require Office installation.
It works on Windows XP, Windows Vista, Windows 7, Windows 2003 Server and
Windows 2008 Server.
Key features
This tool allows you to:
- export data from
Sqldatasource, Dataview, Sql datareader, Datatable, Sqldatareader,
Oledbdatasource, Oledbdatareader, Objectdatasource to Excel 2003, Excel 2007,Excel 2010 and OpenOffice
- export data from different data sources using always the same code
- choose which columns to export
- either infer Excel Column Headers from Gridview Column Headers or set them manually
- obtain Multiple Worksheets Excel 2003/2007/2010 Workbook by providing one Datasource for each Excel Worksheet
- add hyperlink columns to your export by specifying the href
column and text column you want to display
- put a Summary line either at the top or at the bottom of the sheets (with real Excel
formulas)
- add Percentages columns to your sheets. They may be computed between two values
on the same line or a value and a column total (with real Excel formulas).
- display a Title line on each Excel Worksheet
- provide "filter ready" Excel Worksheet
- provide "frozen panes" Excel Worksheet so that the user can scroll
data without losing sight of column headers
- save the Excel to a folder or display the Excel Export immediately to the User
- set a size limit over which the export is compressed to a zip file
- format Excel headers, rows, summary line and bottom lines
The capability to export data from Dataview virtually enables you to extract data from any datatable and, consequently,
from almost any database.
By clicking on next table links, you can look over some Excel 2003/2007/2010 Export Samples.
Internal comments have been manually added to highlight some export feature.
To appreciate differences between xml Excel 2003 format and Excel 2007/2010 xlsx format download and save
on your disk both the XML 2003 Multisheet example and the XLSX 2007 one.
You will verify that the XML file size is about 2,5 MB while the XLSX one is
just 28 KB. If you open them by means of Excel 2007 you'll verify also that
contents are the same.
Tool Installation Requirements
To install and run this tool you need:
- Windows XP or Windows Vista or Windows 7 or Windows 2003 Server or Windows 2008 Server
-
.Net Framework 3.5
What this tool doesn't require
Since this tool produces Excel 2003
xml files and Excel 2007 xlsx files, your server
doesn't require the
installation of any of the following items:
- Office
- VSTO (Visual Studio Tools for Office)
- Excel APIs
ASP.NET
Demo Sites Installation Requirements
To install and run
the
ASP.NET demo sites you need also:
- Microsoft Sql Server (any version)
- Microsoft AdventureWorks demo database
- Visual Studio 2005/2008/2010
The Demo Sites are available both in Visual Basic and C# code.
.NET
Demo Windows Forms Installation Requirements
To install and run
.NET demo Windows Forms sample you need also:
- Visual Studio 2005/2008/2010
The Demo Sites are available both in Visual Basic and C# code.
How it works
After installation and referencing the GEETMultisheets30 dll from your Web Site, the tool
will expose
several Classes. The most important one is the GEETStandard which will
allow you to define woksheets, columns, data providers, formatting and obtain
output.
Exports to Excel
With the Gridview to Excel Export Tool you can:
- immediately response the Excel Workbook to the browser
- save the export to disk
- obtain a MemoryStream avaible for any other use
Click here to free download, install and try the tool.