Link Search Menu Expand Document

ISpreadsheetOptions Interface

Spreadsheet options class

Namespace:Bytescout.Spreadsheet.COM
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master
Syntax
public interface ISpreadsheetOptions

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
Methods
NameDescription
Public methodSetExcel2003Limits
Sets Excel2003 compatible limits (string length, max column count, max row count etc)
Public methodSetExcel2007Limits
Sets Excel2007 compatible limits (string length, max column count, max row count etc)
Public methodSetOpenOffice3Limits
Sets Open Office 3 Calc compatible limits (string length, max column count, max row count etc)
Top
See Also

Reference