Export Excel with image from Gridview in c# winform

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 < exportExcelTodataGridView1.Columns.Count; dataGridViewColumnIndex++)
{
ExportDataGridViewToExcelInCSharpWorkSheet.Cells[1, dataGridViewColumnIndex] = exportExcelTodataGridView1.Columns[dataGridViewColumnIndex - 1].HeaderText;
}
for (int datagridviewrowsindex = 0; datagridviewrowsindex < exportExcelTodataGridView1.Rows.Count; datagridviewrowsindex++)
{
for (int datagridviewcolumnsindex = 0; datagridviewcolumnsindex < exportExcelTodataGridView1.Columns.Count - 1; 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
{
}
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari4y ago
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
+3
Gajendra Jangid4y ago
Hi,

Use Following Link

https://www.aspsnippets.com/Articles/Export-GridView-with-Images-to-Word-Excel-and-PDF-Formats-in-ASP.Net.aspx
+3
Sachin Singh4y ago
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 < exportExcelTodataGridView1.Columns.Count; dataGridViewColumnIndex++)
               {
                   ExportDataGridViewToExcelInCSharpWorkSheet.Cells[1, dataGridViewColumnIndex] = exportExcelTodataGridView1.Columns[dataGridViewColumnIndex - 1].HeaderText;
               }

               for (int datagridviewrowsindex = 0; datagridviewrowsindex < exportExcelTodataGridView1.Rows.Count; datagridviewrowsindex++)
               {
                   for (int datagridviewcolumnsindex = 0; datagridviewcolumnsindex < exportExcelTodataGridView1.Columns.Count - 1; 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
           {

           }
       }
+2
Amit Mohanty4y ago
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/
+2
Leon D4y ago
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
+3
Muhammad Imran Ansari4y ago
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
+3