ExcelWorkbookDefaultSettings Class

A class encapsulating the default options (font, row height, column width) for a newly created workbook.

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 11.0.0
C#
public class ExcelWorkbookDefaultSettings
Inheritance
Object    ExcelWorkbookDefaultSettings

Constructors

ExcelWorkbookDefaultSettingsInitializes a new instance of the ExcelWorkbookDefaultSettings class

Properties

AutoTrustLevel Gets or sets a flag indication if the library should automatically determine the trust level in an ASP.NET environment in order to offer the best performance. Default value is true. When this property is false the trust level is given by the FullTrustAllowed property.
DefaultColumnWidthChars Gets or sets default column width in characters for the newly created worksheets.
DefaultFontName Gets or sets default font name for the newly created worksheets.
DefaultFontSize Gets or sets default font size in points for the newly created worksheets.
DefaultRowHeightPoints Gets or sets default row height in points for the newly created worksheets.
FormulaNumberFormat Gets or sets the number format in formula used when parsing formulas. Set this propery before assigning a formula expression to a cell. The default value is the number format for the current culture.
FormulaParamsSeparator Gets or sets the separator between formula parameters used when parsing formulas. Set this propery before assigning a formula expression to a cell. The defaulr value is ','.
FormulaRowsSeparator Gets or sets the rows separator used when parsing arrays in formulas. Set this propery before assigning a formula expression to a cell. The default value is ';'
FullTrustAllowed Gets or sets a global flag indicating if the ASP.NET Full Trust level can be granted to the library at runtime. This property has effect only if AutoTrustLevel is false. The default value is true and therefore the library assumes it can run in full trust mode. In full trust mode the library can run some speed optimizations to deliver the best performance. Full Trust level is the default level assigned by ASP.NET to the web applications.
ParseCSVStrings Gets or sets a flag indicating if the strings from a CSV file are parsed to produce cells containing numbers, dates or booleans. Default value is true.
SerializeDefaultColumnWidth A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xls_2007.
SerializeDefaultRowHeight A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xlsx_2007.

Methods

Equals
(Inherited from Object)
Finalize
(Inherited from Object)
GetHashCode
(Inherited from Object)
GetType
(Inherited from Object)
MemberwiseClone
(Inherited from Object)
ToString
(Inherited from Object)

See Also