This C# example showcases how to programmatically insert rows into an Excel worksheet at a specified row index using the FileFormat.Cells library.

insert-rows-into-worksheet.cs

using FileFormat.Cells;

// Load the workbook from the specified file path
using (Workbook wb = new Workbook(filePath))
{
    // Access the first worksheet in the workbook
    Worksheet firstSheet = wb.Worksheets[0];

    // Define the starting row index and the number of rows to insert
    uint startRowIndex = 5;
    uint numberOfRows = 3;

    // Insert the rows into the worksheet
    firstSheet.InsertRows(startRowIndex, numberOfRows);

    // Get the total row count after insertion
    int rowsCount = firstSheet.GetRowCount();

    // Output the updated row count to the console
    Console.WriteLine("Rows Count=" + rowsCount);

    // Save the workbook to reflect the changes made
    wb.Save(filePath);

    Console.WriteLine("Rows inserted and workbook saved successfully.");
}