Click or drag to resize

ExcelWorkbookDefaultSettings Class

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

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
Copy
public class ExcelWorkbookDefaultSettings

The ExcelWorkbookDefaultSettings type exposes the following members.

Constructors
  NameDescription
Public methodExcelWorkbookDefaultSettings
Initializes a new instance of the ExcelWorkbookDefaultSettings class
Top
Properties
  NameDescription
Public propertyAutoTrustLevel
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.
Public propertyDefaultColumnWidthChars
Gets or sets default column width in characters for the newly created worksheets.
Public propertyDefaultFontName
Gets or sets default font name for the newly created worksheets.
Public propertyDefaultFontSize
Gets or sets default font size in points for the newly created worksheets.
Public propertyDefaultRowHeightPoints
Gets or sets default row height in points for the newly created worksheets.
Public propertyFormulaNumberFormat
Gets or sets the number format in formula used when parsing formulas. Set this property before assigning a formula expression to a cell. The default value is the number format for the current culture.
Public propertyFormulaParamsSeparator
Gets or sets the separator between formula parameters used when parsing formulas. Set this property before assigning a formula expression to a cell. The default value is ','.
Public propertyFormulaRowsSeparator
Gets or sets the rows separator used when parsing arrays in formulas. Set this property before assigning a formula expression to a cell. The default value is ';'
Public propertyFullTrustAllowed
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.
Public propertyParseCSVStrings
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.
Public propertySerializeDefaultColumnWidth
A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the format is Xls_2007.
Public propertySerializeDefaultRowHeight
A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the format is Xlsx_2007.
Top
See Also