Save Info of Datagridview

Question

How can I save the infor of the datagridView in an excel template?

Arnold Petrona · Answer

Ok question about your code for understanding it : Application oExcel = new Application(); workbook oWorkbook = ( workbook ) oExcel.Worlbooks.add(); Sheet oSheet = ( Sheet )oWorkbook.ActiveSheet; int i=0j=0; foreach(DatagridviewRow row in yourdatagridview) { foreach(DatagridviewColumn column in yourdatagridview) { oSheet.cells[ij] = yourdatagridview[ij].value; i+=1; } j=+1; } Where the word Workbook and Sheet come from?

Bechir Bejaoui · Answer

Try this way add a reference for a COM component called Microsoft Excel 9.0 object library . you can also import the excel library to using tlbimp.exe tool to import the excel 9.0 library then Application oExcel = new Application(); workbook oWorkbook = ( workbook ) oExcel.Worlbooks.add(); Sheet oSheet = ( Sheet )oWorkbook.ActiveSheet; int i=0j=0; foreach(DatagridviewRow row in yourdatagridview) { foreach(DatagridviewColumn column in yourdatagridview) { oSheet.cells[ij] = yourdatagridview[ij].value; i+=1; } j=+1; }