Gets or sets the culture to use as the current culture for the workbook when doing any culture-aware conversions or comparisons. Syntax Property Value The current culture for the workbook or Null to use the threads current culture. Remarks Note: The culture is not saved or loaded in workbook files, so this is only...
Gets the current format of the workbook. This is the format which will be used when saving and imposing format restrictions. Syntax
Gets the collection of custom table styles in the workbook. Syntax
Gets the collection of custom views for the workbook. Syntax Property Value The collection of custom views for the workbook. Remarks Each custom view stores display settings and optionally print settings, which can later be applied to the workbook and its worksheets as one operation, through both the Microsoft Exc...
Gets or sets the date system used internally by Microsoft Excel. Syntax Property Value The date system used internally by Microsoft Excel. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The assigned value is not defined in the DateSystem enumeration.
Gets or sets the default style for tables in the workbook. Syntax Exceptions Exception Description System.ArgumentException The specified value is not in the CustomTableStyles or StandardTableStyles collections. Remarks This can be set to any WorksheetTableStyle in the CustomTableStyles or StandardTableStyles coll...
Gets the properties associated with the workbook document. Syntax Property Value The properties associated with the workbook document. Remarks The document properties are pieces of information which provide details on the content of the workbook, such as the author, title, and subject of the workbook.
The editing culture affects certain language specific features such as formatting of dates. or comparisons. Syntax Remarks Note: The EditingCulture is not saved or loaded in workbook files, so this is only used at when accessing and manipulating objects owned or associated with the Workbook.
Gets the name of the user who initially added file write protection to the document. Syntax Remarks This value is valid if HasFileWriteProtectionPassword or IsFileWriteProtected is true. It will be updated when SetFileWriteProtectionPassword is called and a user name is specified with a new password. Note: The Wor...
Returns the number of columns that are supported by the specified format. Syntax Parameters format The format used by the workbook. Return Value The maximum number of columns supported by the format.