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.

Some methods using this class:

Some properties using for this class:

Some examples using this class:

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.

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


XLAutoFilterMBS   -   XLConditionalFormatMBS


The biggest plugin in space...