Export datagrid to excel

[Benny]

Hello Experts,

I am currently working on a web application using vs.net 2002 with c#.
Assume I have a page with 3 datagrids, how can I export these 3
datagrids to an excel file with 3 sheets, where each sheet contain 1
datagrid data?


Thanks,

Benny

 

[Guest]

Hi

Please check the following articles
http://www.dotnetjohn.com/articles/articleid78.aspx
http://www.c-sharpcorner.com/Code/2003/Sept/ExportASPNetDataGridToExcel.asp
HTH

 

[Benny]

Hello Ravikanth,

I had a brief read on the two articles you sent me. However, these
article seems only demonstrate how to export one datagrid in one excel
file. What I need is multiple datagrids in one excel file with multiple
sheets for each datagrid.


Thanks,

Benny