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: 43.0.35.1049
Syntax
public ExcelFile LoadWithOptions(
	string path,
	Object options
)

Parameters

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

Return Value

Type: ExcelFile
A loaded spreadsheet.
Examples

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