Platforms to show: All Mac Windows Linux Cross-Platform
Back to XLBookMBS class.
XLBookMBS.available as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Returns false on PPC targets.
XLBookMBS.LibVersion as string
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 13.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Returns for example "3.8.0".
With plugin version 17.4 or newer, this returns 4 numbers, so you may see another .0 on the end.
XLBookMBS.LibVersionNumber as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 17.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Returns for example 3 * 256*256*256 + 8 * 256*256 + 0 * 256 + 0.
XLBookMBS.Load2(path as folderitem) as XLBookMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Autodetects if format is old (binary) or new (xml).
Returns nil if error occurs. On success returns a valid book.
Optionally returns error with ErrorMessage parameter.
Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.
See also:
XLBookMBS.Load2(path as folderitem, byref ErrorMessage as String) as XLBookMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Autodetects if format is old (binary) or new (xml).
Returns nil if error occurs. On success returns a valid book.
Optionally returns error with ErrorMessage parameter.
Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.
See also:
XLBookMBS.Load2(path as string) as XLBookMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Autodetects if format is old (binary) or new (xml).
Returns nil if error occurs. On success returns a valid book.
Optionally returns error with ErrorMessage parameter.
Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.
See also:
XLBookMBS.Load2(path as string, byref ErrorMessage as String) as XLBookMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Autodetects if format is old (binary) or new (xml).
Returns nil if error occurs. On success returns a valid book.
Optionally returns error with ErrorMessage parameter.
Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.
See also:
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
XLBookMBS.LoadLibrary(File as FolderItem) as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Returns true on success or false on failure.
While the plugin comes with an internal libXL library, you can use this method to load a different version of the library.
See also:
XLBookMBS.LoadLibrary(Path as string) as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Returns true on success or false on failure.
While the plugin comes with an internal libXL library, you can use this method to load a different version of the library.
See also:
XLBookMBS.LoadRaw2(data as MemoryBlock) as XLBookMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Autodetects if format is old (binary) or new (xml).
Returns nil if error occurs. On success returns a valid book.
Optionally returns error with ErrorMessage parameter.
Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.
See also:
XLBookMBS.LoadRaw2(data as MemoryBlock, byref ErrorMessage as String) as XLBookMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Autodetects if format is old (binary) or new (xml).
Returns nil if error occurs. On success returns a valid book.
Optionally returns error with ErrorMessage parameter.
Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.
See also:
XLBookMBS.LoadRaw2(data as string) as XLBookMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Autodetects if format is old (binary) or new (xml).
Returns nil if error occurs. On success returns a valid book.
Optionally returns error with ErrorMessage parameter.
Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.
See also:
XLBookMBS.LoadRaw2(data as string, byref ErrorMessage as String) as XLBookMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Autodetects if format is old (binary) or new (xml).
Returns nil if error occurs. On success returns a valid book.
Optionally returns error with ErrorMessage parameter.
Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.
See also:
XLBookMBS.SetKeyGlobal(name as string, key as string)
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
shared method | XL | MBS XL Plugin | 12.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
You can call this before using the other plugin functions to set key on application startup. Simply call it in app.open event.
If you have keys for more than one platform, please use #if condition to make sure you pass right key for current platform.
See also:
The items on this page are in the following plugins: MBS XL Plugin.