Insert and Delete a Row
Insert a Row
Code Sample
//Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook();
Worksheet worksheet = workbook.Worksheets[0];
//Insert a row into the worksheet
worksheet.InsertRow(2);
//Save the Excel file
workbook.Save("output.xls");
'Create a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook ()
'Get the first worksheet
Dim worksheet As XlsWorksheet= workbook.Worksheets(0)
'Insert a row into the worksheet
worksheet.InsertRow(2);
'Save the Excel file
workbook.Save("output.xls");
Delete a Row
Code Sample
//Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook();
Worksheet worksheet = workbook.Worksheets[0];
//Delete a row into the worksheet
worksheet.DeleteRow(2);
//Save the Excel file
workbook.Save("book1.xls");
'Create a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook ()
'Get the first worksheet
Dim worksheet As XlsWorksheet= workbook.Worksheets(0)
'Delete a row into the worksheet
worksheet.DeleteRow(2);
'Save the Excel file
workbook.Save("book1.xls");