public abstract class LoadOptions extends Object
Following classes inherit from this base class:
Following code demonstrates different ways of loading
// Loads a spreadsheet from a file with the specified path
ExcelFile ef = ExcelFile.load(fileName);
try (FileInputStream stream = new FileInputStream(fileName)) {
// Loads a spreadsheet from the specified stream
ef = ExcelFile.load(stream, LoadOptions.getXlsxDefault());
}
// Loads a spreadsheet using specified options
XlsxLoadOptions loadOptions = new XlsxLoadOptions();
loadOptions.setPreserveUnsupportedFeatures(false);
ef = ExcelFile.load(fileName, loadOptions);
Modifier and Type | Method and Description |
---|---|
static CsvLoadOptions |
getCsvDefault()
Gets the default options for loading from Character Separated Values file format.
|
static HtmlLoadOptions |
getHtmlDefault()
Gets the default options for loading from HyperText Markup Language File (HTML) format.
|
static OdsLoadOptions |
getOdsDefault()
Gets the default options for loading from OpenDocument Spreadsheet file format.
|
static XlsLoadOptions |
getXlsDefault()
Gets the default options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
|
static XlsxLoadOptions |
getXlsxDefault()
Gets the default options for loading from XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
|
public static CsvLoadOptions getCsvDefault()
MS Excel uses ';' as default if current culture uses ',' for decimal separator. GemBox.Spreadsheet always uses ','.
public static HtmlLoadOptions getHtmlDefault()
public static OdsLoadOptions getOdsDefault()
public static XlsLoadOptions getXlsDefault()
public static XlsxLoadOptions getXlsxDefault()
© GemBox Ltd. — All rights reserved.