This C# example illustrates how to insert a specific number of columns into an Excel worksheet using the Openize.Cells Sdk. The process involves loading the workbook, selecting the target worksheet, inserting the desired number of columns from a specified start column, and saving the workbook to apply the changes.

insert-columns-into-worksheet.cs

using Openize.Cells;
 using (Workbook wb = new Workbook(filePath))
{
    string startColumn = "B";
    int numberOfColumns = 3;


    Worksheet firstSheet = wb.Worksheets[0];


    int columnsCount = firstSheet.GetColumnCount();
    firstSheet.InsertColumns(startColumn, numberOfColumns);

    Console.WriteLine("Columns Count=" + columnsCount);

    wb.Save(filePath);
}