Link Search Menu Expand Document

SpreadsheetOptions Class

Spreadsheet options class
Inheritance Hierarchy
SystemObject
Bytescout.SpreadsheetSpreadsheetOptions

Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.5.1.2018-master
Syntax
[TypeConverterAttribute(typeof(ExpandableObjectConverter))]
public class SpreadsheetOptions : ISpreadsheetOptions

The SpreadsheetOptions type exposes the following members.

Constructors
NameDescription
Public methodSpreadsheetOptions
Initializes a new instance of the SpreadsheetOptions class
Top
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 propertyThrowExceptionOnCalculateError
Gets or sets a value indicating whether [throw exception on calculate error].
Public propertyThrowExceptionOnUnsupportedFormula
Gets or sets a value indicating whether [throw exception on unsupported formula].
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 methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
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)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also

Reference


Copyright © 2016 - 2021 ByteScout