how to export to excel from datatable with contains image path

Question

I have a datatable which contain image path ,i want export to excel my datatable is below

Abhishek Yadav · Answer

To export a datatable to an Excel file using C# in ASP.NET, you can make use of the EPPlus library. Here's an example: First, install the EPPlus NuGet package in your project. Add the following using statements at the top of your code file: using OfficeOpenXml; using System.IO; Create a method to export the datatable to an Excel file: private void ExportToExcel(DataTable dataTable) { using (var package = new ExcelPackage()) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1"); // Set the column headers for (int column = 0; column Call the ExportToExcel method with your datatable as the parameter: DataTable myDataTable = // Your existing datatable here ExportToExcel(myDataTable); When you call the ExportToExcel method, it will create an Excel file with the datatable's data and start downloading it to the user's browser. The file will be named "exported_data.xlsx".

Vishal Yelve · Answer

HI Sandeep, You can use Open XML to download datatable data in excel Do refer below links https://www.aspsnippets.com/Articles/Export-GridView-Data-to-Excel-using-OpenXml-in-ASPNet.aspx https://stackoverflow.com/questions/11811143/export-datatable-to-excel-with-open-xml-sdk-in-c-sharp 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 (); 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(); } }