Insert and Delete Rows or Columns in Excel using C#

InsertDeleteRowsColumns_CSharp.md

Learn how to insert and delete rows or columns in an Excel sheet using C#: https://blog.conholdate.com/2021/10/06/insert-or-delete-rows-and-columns-in-excel-using-csharp/

The following topics are discussed/covered in this article:

1. Insert Rows in Excel Worksheets using C#
2. Insert Rows with Formatting in Excel Worksheets using C#
3. Delete Rows from Excel Worksheets using C#
4. Insert Columns in Excel Worksheets using C#
5. Delete Columns from Excel Worksheets using C#

InsertDeleteRowsColumns_CSharp_DeleteAColumn.cs

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Deleting a 3rd column from the worksheet
worksheet.Cells.DeleteColumn(2);

// Saving the modified Excel file
workbook.Save(@"C:\Files\output.xlsx");

InsertDeleteRowsColumns_CSharp_DeleteColumns.cs

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Deleting 5 columns from the worksheet starting from 3rd column
worksheet.Cells.DeleteColumns(2, 5, false);

// Saving the modified Excel file
workbook.Save(@"C:\Files\output.xlsx");

InsertDeleteRowsColumns_CSharp_DeleteRows.cs

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Deleting 10 rows into the worksheet starting from 3rd row
worksheet.Cells.DeleteRows(2, 10);

// Saving the modified Excel file
workbook.Save(@"C:\Files\output.xlsx");

InsertDeleteRowsColumns_CSharp_InsertColumn.cs

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Inserting a column into the worksheet at 2nd position
worksheet.Cells.InsertColumn(1);

// Saving the modified Excel file
workbook.Save(@"C:\Files\output.xlsx");

InsertDeleteRowsColumns_CSharp_InsertColumns.cs

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Inserting 5 column into the worksheet starting at 2nd position
worksheet.Cells.InsertColumns(2, 5);

// Saving the modified Excel file
workbook.Save(@"C:\Files\output.xlsx");

InsertDeleteRowsColumns_CSharp_InsertRow.cs

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Inserting a row into the worksheet at 3rd position
worksheet.Cells.InsertRow(2);

// Saving the modified Excel file
workbook.Save(@"C:\Files\output.xlsx");

InsertDeleteRowsColumns_CSharp_InsertRows.cs

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Inserting 10 rows into the worksheet starting from 3rd row
worksheet.Cells.InsertRows(2, 10);

// Saving the modified Excel file
workbook.Save(@"C:\Files\output.xlsx");

InsertDeleteRowsColumns_CSharp_InsertRowWithFormatting.cs

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(@"C:\Files\Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Setting Formatting options
InsertOptions insertOptions = new InsertOptions();
insertOptions.CopyFormatType = CopyFormatType.SameAsAbove;

// Inserting a row into the worksheet at 3rd position
worksheet.Cells.InsertRows(2, 1, insertOptions);

// Saving the modified Excel file
workbook.Save(@"C:\Files\output.xlsx");