How to create insert a row using c# interop

Question

Hi All, I want to insert a row in excel and need to insert data for newly inserted row uisng c# interop.

ashok ashok · Answer

Thank for your reply Laxmidhar, But my requirement is need to insert a row and populate row with data.

Laxmidhar Sahoo · Answer

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 { xlWorkSheet.Cells[1, j + 1] = dataGridView1.Columns[j].Name; } for (i = 0; i { for (j = 0; 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 ; } Thanks and regards

How to create insert a row using c# interop

Answers (2)