ISpreadsheetOptions Interface
Free Trial Web API version Licensing Request A Quote
HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM
Spreadsheet options class
Namespace:Bytescout.Spreadsheet.COMAssembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master
Syntax
The ISpreadsheetOptions type exposes the following members.
Properties
Name | Description | |
---|---|---|
AutoFitRowsBeforeSave | Gets or sets a value indicating whether make auto-fit of rows before saving | |
CSVDetectDataTypes | Gets or set a value indicating whether to detect data types when loading delimiter-separated formats (CSV, TXT). | |
MaxColumnCountAllowed | Gets the max column count allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations) | |
MaxRowCountAllowed | Gets the max row count allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations) | |
MaxStringLengthAllowedPerCell | Gets the max string length per cell allowed for the current format limitations set (see methods .SetExcel2003Limits, .SetExcel2007Limits, .SetOpenOffice3Limits to set current limitations) | |
ThrowExceptionsOnFormatIncompatibilities | 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 | |
ThrowExceptionsOnFormatLimits | Gets or sets a value indicating whether [throw exceptions on spreadsheet format limits]. |
Methods
Name | Description | |
---|---|---|
SetExcel2003Limits | Sets Excel2003 compatible limits (string length, max column count, max row count etc) | |
SetExcel2007Limits | Sets Excel2007 compatible limits (string length, max column count, max row count etc) | |
SetOpenOffice3Limits | Sets Open Office 3 Calc compatible limits (string length, max column count, max row count etc) |
See Also