The Gridview to Excel Export Tool allows you to export data from your ASP.NET Web Site into XML Excel 2003 or XLSX Excel 2007 format in a matter of seconds.

Overview

It consists of a dll you just drop into the bin folder of your ASP.NET site.

Former goal of this tool was to allow ASPX developers to export data from any Gridview to 2003/2007 XML Excel Sheets with a few lines of codes. Now the tool has evolved so that you can export data to Excel from any datasource (Sqldatasource, Dataview, Sql datareader) with or without a Gridview web control.

Key features

This tool allows you to:

• export data from Sqldatasource, Dataview and ObjectDataSource to Excel 2003 and Excel 2007
• 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 Sheets Excel 2003 and/or Excel 2007 Workbook by providing one Datasource for each Excel Sheet
• add hyperlink columns to your export by specifying the href column and text column you want to display
• put a Total 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 Sheet
• provide "filter ready" Excel Sheet
• provide "frozen panes" Excel Sheet so that the user can scroll data without losing sight of column headers
• either display the Excel Export immediately to the User or zip it and send it via email
• 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 Export Samples. Internal comments have been manually added to highlight some export feature.

Export Samples	Excel 2003	Excel 2007
Single sheet Workbook	click here	click here
Multi-sheet Workbook	click here	click here

To appreciate differences between Excel 2003 format and Excel 2007 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 2003 Server or Windows 2008 Server
• .Net Framework 3.5
• Microsoft Office Open XML Formats

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) - read this about VSTO and ASP.NET
• Excel APIs

Demo Site Installation Requirements

To install and run this demo site (as is) you need also:

• Microsoft Sql Server (any version)
• Microsoft AdventureWorks demo database

N.B.:The Demo Sites are provided both in Visual Basic and C# code.

How it works

After installation and referencing the dll from your Web Site, the tool exposes following Classes:

• GEET2003EasyResponse
• GEET2003EasyMail
• GEET2003
• GEET2007EasyResponse
• GEET2007EasyMail
• GEET2003

Which Class to use?

• use GEET2003 and GEET2007 Classes  to obtain Multiple Sheets Workbook or to add Percentages and hyperlink Columns
• you will use GEETEasy classes to simply export your datasource data with  two lines of Code

Download it now!

You can download the tool immediately!

• Click here to download, install and try the tool immediately.
• You can run it free on Windows XP/Vista system without any time-limit. You can try it on any Windows Server system for 60 days before trial license expires.