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 createdyou can find the file D:\Excell_Reports.xls); }

Satyapriya Nayak · Answer

No attachment found