Export Excel with image from Gridview in c# winform

Question

I have Database that have records and image path and its shown in gridview when we export from gridview then image should be shown in excel cell i attach images for example

Rijwan Ansari · Answer

You can do this as shown in this article. https://www.aspsnippets.com/Articles/Export-GridView-with-Images-to-Word-Excel-and-PDF-Formats-in-ASP.Net.aspx

Gajendra Jangid · Answer

Hi, Use Following Link https://www.aspsnippets.com/Articles/Export-GridView-with-Images-to-Word-Excel-and-PDF-Formats-in-ASP.Net.aspx

Sachin Singh · Answer

follow this private void btnExportDataGridViewToExcel_Click(object sender, EventArgs e) { _Application ExportDataGridViewToExcelInCSharpApp; _Workbook ExportDataGridViewToExcelInCSharpWorkBook; _Worksheet ExportDataGridViewToExcelInCSharpWorkSheet = null; try { ExportDataGridViewToExcelInCSharpApp = new Microsoft.Office.Interop.Excel.Application(); ExportDataGridViewToExcelInCSharpWorkBook = ExportDataGridViewToExcelInCSharpApp.Workbooks.Add(Type.Missing); ExportDataGridViewToExcelInCSharpWorkSheet = ExportDataGridViewToExcelInCSharpWorkBook.Sheets[ "Sheet1" ]; ExportDataGridViewToExcelInCSharpWorkSheet = ExportDataGridViewToExcelInCSharpWorkBook.ActiveSheet; ExportDataGridViewToExcelInCSharpWorkSheet.Name = "ExportedDataFromDataGridView" ; for ( int dataGridViewColumnIndex = 1; dataGridViewColumnIndex { ExportDataGridViewToExcelInCSharpWorkSheet.Cells[1, dataGridViewColumnIndex] = exportExcelTodataGridView1.Columns[dataGridViewColumnIndex - 1].HeaderText; } for ( int datagridviewrowsindex = 0; datagridviewrowsindex { for ( int datagridviewcolumnsindex = 0; datagridviewcolumnsindex { ExportDataGridViewToExcelInCSharpWorkSheet.Cells[datagridviewrowsindex + 2, datagridviewcolumnsindex + 1] = exportExcelTodataGridView1.Rows[datagridviewrowsindex].Cells[datagridviewcolumnsindex].Value.ToString(); } } SaveFileDialog exportDataGridViewToExcelInCSharpSaveDialog = new SaveFileDialog(); //exportDataGridViewToExcelInCSharpSaveDialog.InitialDirectory = "C:/Users/Authentic/Desktop"; exportDataGridViewToExcelInCSharpSaveDialog.DefaultExt = "xlsx" ; exportDataGridViewToExcelInCSharpSaveDialog.FileName = "ExportDataGridViewToExcelFile" ; exportDataGridViewToExcelInCSharpSaveDialog.Title = "Save Excel File" ; exportDataGridViewToExcelInCSharpSaveDialog.Filter = "Excel Files | *.xls;*.xlsx;*.xlm" ; if (exportDataGridViewToExcelInCSharpSaveDialog.ShowDialog() == DialogResult.OK) { ExportDataGridViewToExcelInCSharpWorkBook.SaveAs(exportDataGridViewToExcelInCSharpSaveDialog.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } ExportDataGridViewToExcelInCSharpWorkBook.Close(); ExportDataGridViewToExcelInCSharpApp.Quit(); } catch (Exception ExportDataGridViewToExcelInCSharException) { MessageBox.Show( "Error " + ExportDataGridViewToExcelInCSharException.Message); } finally { } }

Amit Mohanty · Answer

Hey check the below links https://bytes.com/topic/c-sharp/answers/961993-exception-while-exporting-datagridview-data-images-excel http://mauricemuteti.info/how-to-export-datagridview-to-excel-in-c-sharp/

Leon D · Answer

You can use Free Spire.XLS library to export database to Excel. https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

Muhammad Imran Ansari · Answer

You can check the following link. https://www.aspsnippets.com/Articles/Export-GridView-with-Images-to-Word-Excel-and-PDF-Formats-in-ASP.Net.aspx

Export Excel with image from Gridview in c# winform

Answers (6)