Click or drag to resize

ExcelWorkbook Properties

The ExcelWorkbook type exposes the following members.

Properties
  NameDescription
Public propertyActiveSheetIndex
Gets or sets the active sheet index. The index is zero based. The property can be set with a non-negative value. Returns a negative value when no sheet is active in the workbook.
Public propertyChartWorksheets
Gets the collection of chart worksheets of this workbook.
Public propertyDefaultColumnWidthChars
Gets default column width in characters for the newly created worksheets.
Public propertyDefaultFontName
Gets or sets default font name for the newly created worksheets.
Public propertyDefaultFontSizePoints
Gets or sets default font size in points for the newly created worksheets.
Public propertyDefaultRowHeightPoints
Gets the default row height in points for the newly created worksheets.
Public propertyDocumentProperties
Gets the object encpsulating the document properties like author, title, subject, etc.
Public propertyDocumentSecurity
Gets an object used to manage the document security like workbook structure and windows protection, workbook open/write password protection. Works only for Excel 2003 .xls format.
Public propertyFormat
Gets or sets the Excel workbook format (Excel 97-2003 .xls or Excel 2007-2019 or above .xlsx). This property gives the output format when the workbook is saved and controls the features allowed when the workbook is updated by the library. When creating an empty workbook the format is Excel 97-2003. When the workbook is created from an existing excel file or stream, the format is the format of the opened excel document.
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 propertyLicenseKey
Gets or sets the license key for the library. When this property is set to null value the library works in demo mode.
Public propertyNamedRanges
Gets the named ranges collection of this workbook (Workbook scope named ranges).
Public propertyPalette
Gets the colors palette of the workbook.
Public propertyReadOnly
Gets a value that indicates whether the workbook has been opened as read-only
Public propertyStyles
Gets the cell styles collection of this workbook.
Public propertyUnitsConverter
Gets an object used to convert values between various Excel measurement units (points, pixels, width characters)
Public propertyWorksheets
Gets the worksheets collection of this workbook.
Top
See Also