Open and Save Workbook

Once you create a workbook, you can open the workbook to make modifications and save the changes back to the workbook.

This topic includes the following tasks:

• Open a workbook

• Save a workbook

Open a workbook

You can open an existing workbook by calling the Open method of the Workbook class.

Refer to the following example code to open a workbook.

// Create a new workbook.
var workbook = new Workbook();

// Opening a workbook.
workbook.Open(@"Source.xlsx", OpenFileFormat.Xlsx);

In addition to .xlsx files, you can also open the below file formats by using the overloads of Open method in Workbook class:

• .xlsm

• .xltx

• .csv

• .json

• .ssjson

• .sjs

An exception is thrown if you try to open an unsupported file format. For information about importing JSON, SSJSON, and SJS files with serialization options, see Import and Export SpreadJS Files.

For information about configuring import options when opening Excel files, see Excel Import Options.

Save a workbook

You can save changes made to a workbook by calling the Save method of the Workbook class.

Refer to the following example code to save an Excel workbook.

// Save an excel file (.xlsx document)
workbook.Save("createWorkbook.xlsx");

// Saving an excel file with saveFileFormat.
workbook.Save(@"createWorkbook.xlsx", SaveFileFormat.Xlsx);

In addition to .xlsx files, you can also save files in the below file formats by using the overloads of Save method in Workbook class:

• .xlsm

• .xltx

• .csv

• .html

• .pdf

• .json

• .ssjson

• .sjs

For information about configuring export options when saving Excel files, see Excel Export Options.

See Also

• Import and Export Excel Files

• Import and Export SpreadJS Files

• Import and Export CSV File

• Cut or Copy Across Sheets