C# in asp.net,excel

Hi Kumar, you can accept my answer, if that was useful.

Thanks.

0

thank you i use interop open the excel and write the content ij excel .when i publish web .the server excel file is not open.could not find www/inetpub/rootdirectory could not find the file.debug mode work fine.after publsih not work

0

alice yang10y ago

Hi,

As Bhuvanesh Mohankumar suggested, you can bind the gridview to datatable and then export the datatable to excel.

Check this thread which might helps:

How to Export Datatable to Excel through DataGridView(using Oledb)

http://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-Datatable-to-Excel-through-DataGridView.html

0

Bhuvanesh Mohankumar10y ago

I suggest you an alternate approach.

Where get the data from grid and bind to the DataTable /DataSet

You can easily export or write the content of table from Dataset to Excel.

This is avoid the special character issues.

0