Platforms to show: All Mac Windows Linux Cross-Platform

Back to XLBookMBS class.

XLBookMBS.ActiveSheet as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Active sheet index in this workbook.

(Read and Write property)

XLBookMBS.BiffVersion as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns BIFF version of binary file.

Used for xls format only.
(Read only property)

XLBookMBS.CalcMode as integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 20.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The calculation mode of workbook.

Cal be manual, auto or automatic except for data tables.
See CalcMode* constants.
(Read and Write property)

XLBookMBS.ErrorMessage as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
Property XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the last error message.

(Read only property)

XLBookMBS.Handle as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The internal object reference.

(Read only property)

XLBookMBS.IsDate1904 as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 13.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether dates are 1904 based.

A boolean value that indicates whether the date systems used in the workbook starts in 1904.
True indicates the date system starts in 1904, where January 1, 1904 is the first day in the system.
False indicates the workbook uses the 1900 date system, where January 1, 1900 is the first day in the system.
(Read and Write property)

XLBookMBS.IsTemplate as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether the workbook is template.

The template flag: true - workbook is template, false - workbook is not template (default).
This flag must have a value "true" for template files (xlt and xltx).
(Read and Write property)

XLBookMBS.IsWriteProtected as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 23.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns whether the workbook is marked as read-only.

(Read only property)

XLBookMBS.RefR1C1 as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether the R1C1 reference mode is active.

(Read and Write property)

XLBookMBS.RgbMode as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether the RGB mode is active. Used for xlsx format only.

true - RGB mode, false - Index mode (default).
In RGB mode use PackColor() and UnpackColor() methods for getting/setting colors. Used for xlsx format only.
(Read and Write property)

Some examples using this property:

The items on this page are in the following plugins: MBS XL Plugin.


The biggest plugin in space...