SpreadsheetOptions Class

Spreadsheet options class

Inheritance Hierarchy

SystemObject
Bytescout.SpreadsheetSpreadsheetOptions

Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master

Syntax

[TypeConverterAttribute(typeof(ExpandableObjectConverter))]
public class SpreadsheetOptions : ISpreadsheetOptions

<TypeConverterAttribute(GetType(ExpandableObjectConverter))>
Public Class SpreadsheetOptions
	Implements ISpreadsheetOptions

[TypeConverterAttribute(typeof(ExpandableObjectConverter))]
public ref class SpreadsheetOptions : ISpreadsheetOptions

[<TypeConverterAttribute(typeof(ExpandableObjectConverter))>]
type SpreadsheetOptions =  
    class
        interface ISpreadsheetOptions
    end

The SpreadsheetOptions type exposes the following members.

Constructors

	Name	Description
	SpreadsheetOptions	Initializes a new instance of the SpreadsheetOptions class

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)
	ThrowExceptionOnCalculateError	Gets or sets a value indicating whether [throw exception on calculate error].
	ThrowExceptionOnUnsupportedFormula	Gets or sets a value indicating whether [throw exception on unsupported formula].
	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
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetType	Gets the type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	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)
	ToString	Returns a string that represents the current object. (Inherited from Object.)