Winnovative Excel Library

ExcelWorkbookDefaultSettings Class

Winnovative Excel Library Documentation
A class encapsulating the default options (font, row height, column width) for a newly created workbook.
Inheritance Hierarchy

SystemObject
  Winnovative.ExcelLibExcelWorkbookDefaultSettings

Namespace:  Winnovative.ExcelLib
Assembly:  wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)
Syntax

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 propery 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 propery before assigning a formula expression to a cell. The defaulr value is ','.
Public propertyFormulaRowsSeparator
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 ';'
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 the format is Xls_2007.
Public propertySerializeDefaultRowHeight
A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xlsx_2007.
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 methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also

Reference