Loading

how to export two gridviews in same excel but differentsheet

Iswarya Rengarajan

Hi,

i have two gridviews in my aspx page gridview1 and gridview2

i bind Datatable1 in gridview1 and Datatable2 in gridview2

how can i export these gridviews in same excel but different sheets like gridview1 in sheet1

and gridview2 in sheet2 .

i am new to development i found many links in google but those links not helpful please guide me to do this.

Thanks and Regards,

Iswarya.R

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel9y ago
You can take a look at working exmple in one of my articles at
http://www.c-sharpcorner.com/article/exporting-datagrid-to-excel-in-wpf/

and make sure to do the same thing after creating new worksheet in current work book using below methods.
Excel.Worksheet newWorksheet;
newWorksheet = (Excel.Worksheet)Globals.ThisWorkbook.Worksheets.Add();
0
Rajkiran Swain9y ago
https://stackoverflow.com/questions/13827651/how-to-export-two-gridviews-in-same-excel-file-on-different-worksheets
0