ExcelWorkbookDefaultSettings Properties

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.

Gets or sets default column width in characters for the newly created worksheets.

Gets or sets default font name for the newly created worksheets.

Gets or sets default font size in points for the newly created worksheets.

Gets or sets default row height in points for the newly created worksheets.

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.

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 ','.

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 ';'

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.

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.

A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xls_2007.

A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xlsx_2007.