User-766375372 posted
Folks,
Here's a "free" to use Export To Excel control
http://www.codeplex.com/ExportToExcel that I published recently.
This control, allows you to "Export" the contents of your "GridView" control to Excel {no coding required}.
Usage
Simply drag and drop the ExportToExcel button on your page and enjoy "Zero code" export feature.
Features:
1) Styling : If you used "HeaderStyle", "RowStyle", "AlternateRowStyle" in your GridView, you can simply enable styling by setting the "ApplyStyleInExcel' property to "True". Note: CSS styling is not supported at this point {future release}
2) TimeStamp: If you set the "IncludeTimeStamp" to true, the filename is appended with a "time Stamp". These are very useful for time sensitive reports.
3) PageSize: If you are using Pagination in your GridView, you can choose to export the "Current" page, the "Entire Grid"
all pages or set a specific number of records to export. Use "All" for all pages, "Current" for the current page and 20 for first 20 records.
4) Sorting: The Export supports sorting. In otherwords, if you sort your gridview and then export, the excel spreadsheet will also be sorted.
5) GridViewID: If you have more than one gridview in a page, you can specify which gridview you'd like to export by setting this property. You do not have to set any value if you just have one grid view.
6) File Name: You can set the filename that you want to export.
