Export data from dataset to excel in c#

Export data from dataset to excel in c#

 

ExcelDocument xls = new ExcelDocument();
xls.easy_WriteXLSFile_FromDataSet("ExclFile.xls", dataset, 
                 new ExcelAutoFormat(Styles.AUTOFORMAT_EASYXLS1), "Sheet_Name");

 

C# Excel library can also be used to export the dataset. More details about how to export can be found here.

2021-10-03