convert the saving record into excel

Question

i want to convert the saving record into excel i send the attach filed see and convert into excel please help me. Regards, Narasimn P

divya · Answer

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 { ExcelApp.Cells[1, i] = datagridview1.Columns[i - 1].HeaderText; } for (int i = 0; i { for (int j = 0; 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"); }

Satyapriya Nayak · Answer

No attachment found

convert the saving record into excel

Answers (2)