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

534

Coading

Answers (1)

Forum Statistics

Please welcome our newest member Denise Chin.
3,096,224 users have contributed to 147,391 threads and 483,654
In the past 24 hours, we have 1 new threads, 5 new posts, and 116 new users.
In last week, the most popular thread is 'How do generations (Gen0, Gen1, Gen2, LOH) work in .NET GC?'.

Upcoming Events

View all

Secure External Access: Configure Microsoft Entra ID for Power Pages - Microsoft Business Application: Ep.33
AI Agents Conference - 2025