Platforms to show: All Mac Windows Linux Cross-Platform

XLBookMBS class

Type Topic Plugin Version macOS Windows Linux iOS Targets
class XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The central class for a workbook.
Example
// create new Excel file, pass true for XLSX format or false for older XLS format
Var book As New XLBookMBS(True)

// add sheet
Var sheet As XLSheetMBS = book.addSheet("Test")
Call sheet.WriteString(2, 1, "Hello World", Nil)

// write file and launch
Var file As FolderItem = SpecialFolder.Desktop.Child("Writing data.xlsx")

If book.Save(file) Then
file.Launch
Else
MsgBox "Failed to create file."+EndOfLine+EndOfLine+book.ErrorMessage
End If

The MBS Xojo XL Plugin is based on LibXL, a powerful library to handle Excel files.

You'll need your own license for LibXL. For more information go here:
https://www.monkeybreadsoftware.de/xojo/plugin-xls.shtml

When you have obtained license file inside your XOJO project place XLBookMBS.SetKeyGlobal call with LibXL license in app.open.

This class has no sub classes.

Blog Entries

Xojo Developer Magazine

Release notes

  • Version 25.1
    • Changed SetLicenseKey in XLBookMBS class to raise exception if you pass invalid license, e.g. Windows license on macOS, instead of ignoring it.
  • Version 25.0
    • Added RemoveAllPhonetics and CoreProperties methods to XLBookMBS class.
  • Version 24.3
    • Fixed a problem with XLBookMBS when using conditional formatting.
  • Version 24.2
    • Added keepAllSheets parameter for LoadPartially methods in XLBookMBS class.
    • Added PictureTypeSVG constant for XLBookMBS class.
  • Version 23.3
    • Added AddFormatFromStyle method for XLBookMBS class.
  • Version 23.1
    • Added IsWriteProtected method to XLBookMBS class.
  • Version 20.1
    • Fixed a problem with returning dates in Xojo which affects XLBookMBS.UnpackDate function and others.
  • Version 18.4
  • Version 18.3
    • Added SetKeyGlobal private method to XLBookMBS class to cause compiler error if you call SetKeyGlobal with an object. Please call only in app.open with shared method.
    • Changed DynaPDFMBS.SetLicenseKeyGlobal and XLBookMBS.SetKeyGlobal to raise exception if debugging, if called twice to notify developer about misuse.

Some methods using this class:

Some properties using for this class:

Some examples using this class:

Some related classes:


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


XLAutoFilterMBS   -   XLConditionalFormatMBS


The biggest plugin in space...