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=0,j=0; foreach(DatagridviewRow row in yourdatagridview) { foreach(DatagridviewColumn column in yourdatagridview) { oSheet.cells[i,j] = yourdatagridview[i,j].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=0,j=0; foreach(DatagridviewRow row in yourdatagridview) { foreach(DatagridviewColumn column in yourdatagridview) { oSheet.cells[i,j] = yourdatagridview[i,j].value; i+=1; } j=+1; }

Save Info of Datagridview

Answers (2)