C# GridView export to Excel

Hi Guys,

Please could you help me.

I try to export from DataGridView to Excel.

This is my code for the "Export" button:

        private void pb_export_Click(object sender, EventArgs e)
        {
            saveFileDialog1.InitialDirectory = "C:";
            saveFileDialog1.Title = "Export to excel as";
            saveFileDialog1.FileName = "";
            saveFileDialog1.Filter = "Excel Files (2003 *.xls)|*.xls|Excel Files (2007 *.xlsx)|*.xlsx";
            if (saveFileDialog1.ShowDialog() != DialogResult.Cancel)
            {
                Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application();
                ExcelApp.Application.Workbooks.Add(Type.Missing);
                ExcelApp.Columns.ColumnWidth = 10;

                for (int i = 0; i < dgw_data.Rows.Count; i++)
                {
                    DataGridViewRow row = dgw_data.Rows[i];
                    for (int j = 0; j < row.Cells.Count; j++)
                    {
                        ExcelApp.Cells[i + 1, j + 1] = row.Cells[j].ToString();
                    }
                }

                ExcelApp.ActiveWorkbook.SaveCopyAs(saveFileDialog1.FileName.ToString());
                ExcelApp.ActiveWorkbook.Saved = true;
                ExcelApp.Quit();
            }
        }

The output Excel file doesn't containing values:

DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=0 }	DataGridViewTextBoxCell { ColumnIndex=1, RowIndex=0 }
DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=1 }	DataGridViewTextBoxCell { ColumnIndex=1, RowIndex=1 }
DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=2 }	DataGridViewTextBoxCell { ColumnIndex=1, RowIndex=2 }
DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=3 }	DataGridViewTextBoxCell { ColumnIndex=1, RowIndex=3 }
DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=4 }	DataGridViewTextBoxCell { ColumnIndex=1, RowIndex=4 }
DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=5 }	DataGridViewTextBoxCell { ColumnIndex=1, RowIndex=5 }
DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=6 }	DataGridViewTextBoxCell { ColumnIndex=1, RowIndex=6 }
DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=7 }	DataGridViewTextBoxCell { ColumnIndex=1, RowIndex=7 }

Your help would be great.

Thanks,

Timur

4 Replies

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

Munesh Sharma11y ago
Accepted answer
http://csharp.net-informations.com/excel/csharp-excel-datagridview.htm
0
Timur Lenk11y ago
Thank you very much Guys! These were very helpful!

Have a nice day!

Timur
0
Rajeesh Menoth11y ago
Hi,

Refer the below articles :

http://www.aspsnippets.com/Articles/Export-GridView-to-Excel-in-ASPNet-with-Formatting-using-C-and-VBNet.aspx

http://www.aspdotnet-suresh.com/2015/09/export-datatable-to-excel-in-windows-application-using-csharp-vbnet.html

http://www.c-sharpcorner.com/UploadFile/0c1bb2/export-gridview-to-excel/

The answer is helpful.Then accept the answer..!!
0
Vinodh Narayanan11y ago
Dear Timuk

Please follow this link hope it will be really helpful to you

http://www.codeproject.com/Tips/545456/Exporting-DataGridview-To-Excel

"Please mark if accepted as a answer"

Regards
Vinodh.N
Sharepoint developer/Administrator
0