Free:Export Gridview to Excel RSS

• • Reply
  

  sendemailtor...

  Member

  10 Points

  38 Posts

  Free:Export Gridview to Excel

  Oct 07, 2007 11:15 AM|sendemailtorajesh|LINK

  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.
  

  Gridview Export to Excel

• • Reply
  

  dotnetguts

  Member

  77 Points

  75 Posts

  Re: Free:Export Gridview to Excel

  Jun 13, 2008 12:28 AM|dotnetguts|LINK

  This can also help you out, quickly embedding code and gets thing done.

  http://dotnetguts.blogspot.com/2007/12/export-datagrid-to-excel-in-aspnet.html

• Import Excel To Datagrid ASP.net
• Export Datagrid Data To Excel