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

572

1 ASP.NET Core

Coading

Answers (1)

Forum Statistics

Please welcome our newest member Brady Smith.
3,101,910 users have contributed to 147,373 threads and 483,786
In the past 24 hours, we have 0 new threads, 1 new posts, and 124 new users.
In last week, the most popular thread is '.NET CORE WEB API'.

Upcoming Events

View all

AI Agents Conference - 2025
.NET Conf - Rasipuram
TONATHON 2025

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

How to export data from asp.net control msexcel

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)