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