You can use OpenXML . private static void WriteExcelFile(DataTable table, string outputPath) { using (SpreadsheetDocument document = SpreadsheetDocument.Create(outputPath, SpreadsheetDocumentType.Workbook)) { WorkbookPart workbookPart = document.AddWorkbookPart(); workbookPart.Workbook = new Workbook(); WorksheetPart worksheetPart = workbookPart.AddNewPart (); var sheetData = new SheetData(); worksheetPart.Worksheet = new Worksheet(sheetData); Sheets sheets = workbookPart.Workbook.AppendChild( new Sheets()); Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "mySheet" }; sheets.Append(sheet); Row headerRow = new Row(); List columns = new List string >(); foreach (System.Data.DataColumn column in table.Columns) { columns.Add(column.ColumnName); Cell cell = new Cell(); cell.DataType = CellValues.String; cell.CellValue = new CellValue(column.ColumnName); headerRow.AppendChild(cell); } sheetData.AppendChild(headerRow); foreach (DataRow dsrow in table.Rows) { Row newRow = new Row(); foreach (String col in columns) { Cell cell = new Cell(); cell.DataType = CellValues.String; cell.CellValue = new CellValue(dsrow[col].ToString()); newRow.AppendChild(cell); } sheetData.AppendChild(newRow); } workbookPart.Workbook.Save(); } } Or also you can store data in the dataset and export in excel.. public async Task DownloadExcelDocument() { var _dataSet = await BindData(); string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" ; string fileName = "Report.xlsx" ; try { using (var workbook = new XLWorkbook()) { workbook.Worksheets.Add(_dataSet); using (var stream = new MemoryStream()) { workbook.SaveAs(stream); var content = stream.ToArray(); return File(content, contentType, fileName); } } } catch (Exception ex) { throw ex; } }

Answer

How to export data from asp.net control msexcel

Insaf khan

492

Coading

Answers (1)

Next Recommended Forum

Can we inject the service dependency in the controller ?

How can we do the automatic model binding in Razor pages in Asp.net co

Forum Statistics

Please welcome our newest member Geo Green.
3,089,804 users have contributed to 147,411 threads and 483,553
In the past 24 hours, we have 9 new threads, 18 new posts, and 231 new users.
In last week, the most popular thread is 'what are libraries are there in python for Schedule'.

Upcoming Events

View all

Get Web3 Ready: Dive into Blockchain with C# Corner
Vibe Coding Bootcamp
Software Architecture Conference - 2025