Export ASP.NET DataGrids to multiple Excel sheets
presently i have 4 datagrids and i want each datagrid to be exported to a new excel sheet. i am able to get the info. of the 4 datagrids in 1 excel sheet but is it possible to send each one to a different sheet?
otherwise i can try putting page breaks so that i can distinguish the data..can someone please tell me how to insert page breaks in C# for excel sheets. or a solution to the previous question..
thanks,
vic.