Workbook Operations in Windows Forms Spreadsheet

27 May 20262 minutes to read

This section explains how to manage Excel workbooks in Spreadsheet, including creating new files, opening existing workbooks from various sources, and saving changes efficiently.

Creating a new Excel Workbook

A new workbook can be created by using a Create method with specified number of worksheets. By default, a workbook will be created with single worksheet.

Form1.cs

....
public Form1()
{
    InitializeComponent();
    spreadsheet.Create(2);
}
....

Opening an existing Excel Workbook

The Excel Workbook can be opened in Spreadsheet using the Open method in various ways,

Form1.cs

....
public Form1()
{
    InitializeComponent();

    // Using Stream
    spreadsheet.Open(Stream file);

    // Using string (file path)
    spreadsheet.Open(string file);

    // Using Workbook
    spreadsheet.Open(IWorkbook workbook);

    // Example: Open from file path
    spreadsheet.Open(@"..\..\Data\Outline.xlsx");
}
....

Opening Excel File in Spreadsheet

Saving the Excel Workbook

The Excel workbook can be saved in Spreadsheet using Save method. If the workbook already exists in the system drive, it will be saved in the same location, otherwise Save Dialog box opens to save the workbook in user specified location.

Form1.cs

....
public Form1()
{
    InitializeComponent();
    
    .....
    spreadsheet.Save();
    .....
}
....

You can also use SaveAs method directly to save the existing excel file with modifications.

The SaveAs method in Spreadsheet can be used in various ways,

Form1.cs

....
public Form1()
{
    InitializeComponent();

    .....
    
    // Using Stream
    spreadsheet.SaveAs(Stream file);

    // Using string (file path)
    spreadsheet.SaveAs(string file);

    // Using dialog box
    spreadsheet.SaveAs();

    .....
}
....