Click or drag to resize

ComHelperLoadWithOptions Method

Loads a spreadsheet from a file with the specified path.

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version:
public ExcelFile LoadWithOptions(
	string path,
	Object options


Type: SystemString
The path from which to load a spreadsheet.
Type: SystemObject
The loading options which can be used to define settings for load operation.

Return Value

Type: ExcelFile
A loaded spreadsheet.

Following code demonstrates different ways of loading ExcelFile.

// Loads a spreadsheet from a file with the specified path
ExcelFile ef = ExcelFile.Load(fileName);

using (FileStream stream = new FileStream(fileName, FileMode.Open))
    // Loads a spreadsheet from the specified stream
    ef = ExcelFile.Load(stream, LoadOptions.XlsxDefault);

// Loads a spreadsheet using specified options
ef = ExcelFile.Load(fileName, new XlsxLoadOptions() { PreserveUnsupportedFeatures = false });
See Also