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

426

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

Leaderboard

View all

Rodrigo Diaz

+12

Magnus Mårtensson

Tuhin Paul

View all

Yesterday's leader

Rodrigo Diaz

Software Architecture, Cloud computing, Cloud-native apps, AI, .NET, C#

Mexico

184

12.7k

10.5k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

285.9k

10.4k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

17.7k

58k

Upcoming events

View all

Suggested for you

View all

Anoop Kumar Sharma

Oscar Santos

Saksham Gupta

Rajkiran Swain

Baraneetharan Ramasamy

Forum Statistics

Please welcome our newest member Kiran .
3,076,323 users have contributed to 147,419 threads and 483,388
In the past 24 hours, we have 8 new threads, 22 new posts, and 248 new users.
In last week, the most popular thread is 'Delta lake vs Lakehouse in Fabric?'.