Export data to multiple Excel Sheets (Worksheets) in ASP.Net using C# and VB.Net

Question

Hii I want to export HTML pages with multiple Sheets into single EXCEFor Ex In Excel on first sheet having master data of 10 recodeds and other sheets are details of that master data with is in html form Kindly help me out

Andrea · Accepted Answer

Hi gauravsPlease try the followingExport DataGridView to template excel with multiple sheet using C and VBNet in Windows Forms ApplicationIt might help youCheers Andrea

dharmendr · Answer

Hi gauravsYou can create a dataset and add the records to seperate DataTableThen loop through the DataTable inside the DataSet and add as Excel Worksheet to exportRefer below articleExport DataSet DataTables to multiple Excel Sheets Worksheets in ASPNet using C and VBNet

Export data to multiple Excel Sheets (Worksheets) in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us