how to export two gridviews in same excel but differentsheet

Question

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

Tapan Patel · Answer

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();

Rajkiran Swain · Answer

https://stackoverflow.com/questions/13827651/how-to-export-two-gridviews-in-same-excel-file-on-different-worksheets