Link Search Menu Expand Document

ISpreadsheetOptions Properties

The ISpreadsheetOptions type exposes the following members.

Properties
NameDescription
Public propertyAutoFitRowsBeforeSave
Gets or sets a value indicating whether make auto-fit of rows before saving
Public propertyCSVDetectDataTypes
Gets or set a value indicating whether to detect data types when loading delimiter-separated formats (CSV, TXT).
Public propertyMaxColumnCountAllowed
Gets the max column count allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations)
Public propertyMaxRowCountAllowed
Gets the max row count allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations)
Public propertyMaxStringLengthAllowedPerCell
Gets the max string length per cell allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations)
Public propertyThrowExceptionsOnFormatIncompatibilities
Throw the exception if data can be corrupted while saving to the file or stream (usually this applies, for example, if you save into XLS format while spreadsheet contains formatting not supported by XLS format but supported by XLSX format only) False by default
Public propertyThrowExceptionsOnFormatLimits
Gets or sets a value indicating whether [throw exceptions on spreadsheet format limits].
Top
See Also

Reference


Copyright © 2016 - 2021 ByteScout