convert the saving record into excel

Hai ...

Here is the code to export the datagridview data to the excel ..please check it once

Firstly you have to add reference microsoft.Office.Inerop.Excel to the project.

(go to Project ->right click on references-> click on Add References->then chhose microsoft.Office.Inerop.Excel)

private void btnExport_Click(object sender, EventArgs e)

{

// For export data in gridview to MS Excell

Microsoft.Office.Interop.Excel.ApplicationClass ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();

ExcelApp.Application.Workbooks.Add(Type.Missing);

ExcelApp.Columns.ColumnWidth = 10;

for (int i = 1; i < datagridview1.Columns.Count + 1; i++)

{

ExcelApp.Cells[1, i] = datagridview1.Columns[i - 1].HeaderText;

}

for (int i = 0; i < datagridview1.Rows.Count - 1; i++)

{

for (int j = 0; j < datagridview1.Columns.Count; j++)

{

ExcelApp.Cells[i + 2, j + 1] = datagridview1.Rows[i].Cells[j].Value.ToString();

}

ExcelApp.ActiveWorkbook.SaveCopyAs("D:\\Excell_Reports.xls");

ExcelApp.ActiveWorkbook.Saved = true;

ExcelApp.Quit();

MessageBox.Show("Excel file created,you can find the file D:\\Excell_Reports.xls");

}

2 Replies

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