XlsWorkbook Properties

Gets the active worksheet.

Gets or sets the index of the active worksheet in the workbook.

Returns collection of add-in functions. Read-only.

Indicates whether to allow usage of 3D ranges in DataValidation list property (MS Excel doesn't allow).

Formula arguments separator.

Returns or sets the author of the comment. Read / write String.

Returns collection that represents all the built-in document properties for the specified workbook. Read-only.

Collection of the chart objects.

Gets the list of chart sheets.

Gets or sets the code name of the worksheets.

First free shape id.

Current object id.

First free shape id.

Returns collection that represents all the custom document properties for the specified workbook. Read-only.

Gets the data connections associated with the workbook.

Gets or sets a value indicating whether the workbook should use the 1904 date system.

Returns index to the default extended format.

Indicates whether library should try to detect string value passed to Value (and Value2) property as DateTime. Setting this property to false can increase performance greatly for such operations especially on Framework 1.0 and 1.1. Default value is true.

Gets or sets a value indicating whether macros are disabled at the start.

Index of the tab which will be displayed on document open.

Indicates whether workbook tabs are visible.

Gets the collection of external links in the workbook.

Gets or sets the size of the first character.

Gets or sets the full file name of the workbook.

Gets or sets a value indicating whether the names are duplicated.

Gets or sets a value indicating whether the workbook has macros.

Gets the collection of add-in functions.

Gets the collection of fonts used within the spreadsheet.

Gets the inner graphics object.

Gets the inner palette of colors.

Gets the inner worksheets collection.

True if cells are protected.

Indicates whether the workbook uses precision.

Gets/Sets value to display horizontal scrollbar

Gets a value indicating whether the object is loaded.

Indicates whether worksheet is displayed right to left.

Gets/Sets value to display vertical scrollbar

True if window is protected.

Gets or sets a value indicating whether the current instance is in a loading state. This property is internal and can only be accessed within the same assembly.

Returns maximum column count for each worksheet in this workbook. Read-only.

Gets the maximum width of a digit in the current font and size.

Gets the maximum indentation level.

Returns maximum row count for each worksheet in this workbook. Read-only.

Returns maximum possible number of extended formats. Read-only.

For an ReservedHandle object, it returns a Names collection that represents all the names in the active workbook. For a Workbook object, it returns a Names collection that represents all the names in the specified workbook (including all worksheet-specific names).

Gets the count of objects in the collection.

Gets or sets the collection of objects in the workbook.

Gets or sets the OleSize property.

Gets the color palette.

Reference to Parent object. Read-only.

Gets / sets password to encrypt document.

True if the workbook has been opened as Read-only. Read-only Boolean.

True to display a message when the file is opened, recommending that the file be opened as read-only.

Get quantity of instance references.

Gets / sets row separator for array parsing.

Gets or sets a value indicating whether the object has been saved.

Gets or sets a value indicating whether the object is currently in a saving state.

Gets or sets the size of the second character.

Gets or sets the standard font for the workbook.

Gets or sets the standard font size for the workbook.

Gets or sets the standard row height for all worksheets in the workbook.

Gets or sets the standard row height in pixels.

Returns a Styles collection that represents all the styles in the specified workbook. Read-only.

Returns collection with all tabsheets in the workbook. Read-only.

ThrowOnUnknownNames

Gets or sets the Excel version of the workbook.

Returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.