How to create insert a row using c# interop

try
{
string filename1 = "Damage Product List";
filename1 = "D:\\Report\\" + filename1 + ".xls";
Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int i = 0;
int j = 0;
for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
{
xlWorkSheet.Cells[1, j + 1] = dataGridView1.Columns[j].Name;
}
for (i = 0; i <= dataGridView1.RowCount - 1; i++)
{
for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
{
DataGridViewCell cell = dataGridView1[j, i];
xlWorkSheet.Cells[i + 2, j + 1] = cell.Value;
}
}
xlWorkBook.SaveAs(filename1, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
MessageBox.Show("Excel file created , you can find the file");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
return;
}

2 Replies

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

ashok ashok6y ago
Thank for your reply Laxmidhar, But my requirement is need to insert a row and populate row with data.
0
Laxmidhar Sahoo6y ago
1. try
2. {
3. string filename1 = "Damage Product List";
6. filename1 = "D:\\Report\\" + filename1 + ".xls";
7. Microsoft.Office.Interop.Excel.Application xlApp;
8. Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
9. Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
10. object misValue = System.Reflection.Missing.Value;
12. xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
13. xlWorkBook = xlApp.Workbooks.Add(misValue);
14. xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
15. int i = 0;
16. int j = 0;
19. for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
20. {
21. xlWorkSheet.Cells[1, j + 1] = dataGridView1.Columns[j].Name;
22. }
25. for (i = 0; i <= dataGridView1.RowCount - 1; i++)
26. {
27. for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
28. {
29. DataGridViewCell cell = dataGridView1[j, i];
30. xlWorkSheet.Cells[i + 2, j + 1] = cell.Value;
31. }
32. }
33. xlWorkBook.SaveAs(filename1, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
34. xlWorkBook.Close(true, misValue, misValue);
35. xlApp.Quit();
40. MessageBox.Show("Excel file created , you can find the file");
43. }
44. catch (Exception ex)
45. {
48. MessageBox.Show(ex.Message.ToString());
49. return;
50. }
Thanks and regards
0