Platforms to show: All Mac Windows Linux Cross-Platform

XLBookMBS class

// 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

• 10 properties
  • property ActiveSheet as Integer
  • property BiffVersion as Integer
  • property CalcMode as integer
  • Property ErrorMessage as string
  • property Handle as Integer
  • property IsDate1904 as boolean
  • property IsTemplate as boolean
  • property IsWriteProtected as Boolean
  • property RefR1C1 as Integer
  • property RgbMode as boolean
• 77 methods
  • method AddConditionalFormat as XLConditionalFormatMBS
  • method AddCustomNumFormat(customNumFormat as string) as Integer
  • method AddFont(initFont as XLFontMBS = nil) as XLFontMBS
  • method AddFormat(initFormat as XLFormatMBS = nil) as XLFormatMBS
  • method AddFormatFromStyle(style as Integer) as XLFormatMBS
  • method AddPicture(path as folderitem) as Integer
  • method AddPicture(path as string) as Integer
  • method AddPictureData(data as string) as Integer
  • method AddRichString as XLRichStringMBS
  • method AddSheet(name as string, initSheet as XLSheetMBS = nil) as XLSheetMBS
  • method AddStyledText(StyledText as StyledText) as XLRichStringMBS
  • method BookRemoveVBA as boolean
  • method BookVersion as Integer
  • method Constructor(xml as boolean = false)
  • method CopyContent(dest as XLBookMBS, Options as XLCopyOptionsMBS = nil)
  • method CoreProperties as XLCorePropertiesMBS
  • method CustomNumFormat(fmt as Integer) as string
  • method DefaultFont(byref fontSize as Integer) as string
  • method DelSheet(index as Integer) as boolean
  • method Font(index as Integer) as XLFontMBS
  • method FontCount as Integer
  • method Fonts as XLFontMBS()
  • method Format(index as Integer) as XLFormatMBS
  • method FormatCount as Integer
  • method Formats as XLFormatMBS()
  • method InsertSheet(index as Integer, name as string = "", initSheet as XLSheetMBS = nil) as XLSheetMBS
  • method Load(path as folderitem) as boolean
  • method Load(path as string) as boolean
  • method LoadMT(path as folderitem) as boolean
  • method LoadMT(path as string) as boolean
  • method LoadPartially(path as folderitem, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
  • method LoadPartially(path as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
  • method LoadPartiallyUsingTempFile(path as folderitem, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, TempFile as folderitem, keepAllSheets as Boolean = false) as boolean
  • method LoadPartiallyUsingTempFile(path as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, TempFile as String, keepAllSheets as Boolean = false) as boolean
  • method LoadRaw(data as MemoryBlock) as boolean
  • method LoadRaw(data as string) as boolean
  • method LoadRawMT(data as MemoryBlock) as boolean
  • method LoadRawMT(data as string) as boolean
  • method LoadRawPartially(data as MemoryBlock, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
  • method LoadRawPartially(data as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
  • method LoadUsingTempFile(path as folderitem, TempFile as folderitem) as boolean
  • method LoadUsingTempFile(path as string, TempFile as String) as boolean
  • method MoveSheet(SourceIndex as integer, DestIndex as Integer) as boolean
  • method PackColor(ColorValue as color) as Integer
  • method PackColor(red as Integer, green as Integer, blue as Integer) as Integer
  • method PackDate(d as date) as Double
  • method PackDate(year as Integer, month as Integer, day as Integer, hour as Integer = 0, min as Integer = 0, sec as Integer = 0, msec as Integer = 0) as Double
  • method PackDateTime(d as dateTime) as double
  • method Picture(index as Integer, byref data as string) as Integer
  • method PictureCount as Integer
  • method RemoveAllPhonetics
  • method RemovePrinterSettings as boolean
  • method Save(path as folderitem) as boolean
  • method Save(path as folderitem, UseTempFile as Boolean) as boolean
  • method Save(path as string) as boolean
  • method Save(path as string, UseTempFile as Boolean) as boolean
  • method SaveMT(path as folderitem) as boolean
  • method SaveMT(path as string) as boolean
  • method SaveRaw(byref data as MemoryBlock) as boolean
  • method SaveRaw(byref data as string) as boolean
  • method SaveRawMT(byref data as MemoryBlock) as boolean
  • method SaveRawMT(byref data as string) as boolean
  • method SetDefaultFont(fontName as string, fontSize as Integer)
  • method SetKey(name as string, key as string)
  • method SetKeyGlobal(name as string, key as string)   Private
  • method SetLocale(locale as string)
  • method Sheet(index as Integer) as XLSheetMBS
  • method SheetCount as Integer
  • method Sheets as XLSheetMBS()
  • method SheetType(index as Integer) as Integer
  • method UnpackColor(ColorValue as Integer) as color
  • method UnpackColor(ColorValue as Integer, byref red as Integer, byref green as Integer, byref blue as Integer)
  • method UnpackDate(Value as Double) as date
  • method UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer) as boolean
  • method UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer, byref hour as Integer, byref min as Integer, byref sec as Integer) as boolean
  • method UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer, byref hour as Integer, byref min as Integer, byref sec as Integer, byref msec as Integer) as boolean
  • method UnpackDateTime(Value as double) as dateTime
• 15 shared methods
  • shared method available as boolean
  • shared method LibVersion as string
  • shared method LibVersionNumber as Integer
  • shared method Load2(path as folderitem) as XLBookMBS
  • shared method Load2(path as folderitem, byref ErrorMessage as String) as XLBookMBS
  • shared method Load2(path as string) as XLBookMBS
  • shared method Load2(path as string, byref ErrorMessage as String) as XLBookMBS
  • shared method LoadError as String
  • shared method LoadLibrary(File as FolderItem) as boolean
  • shared method LoadLibrary(Path as string) as boolean
  • shared method LoadRaw2(data as MemoryBlock) as XLBookMBS
  • shared method LoadRaw2(data as MemoryBlock, byref ErrorMessage as String) as XLBookMBS
  • shared method LoadRaw2(data as string) as XLBookMBS
  • shared method LoadRaw2(data as string, byref ErrorMessage as String) as XLBookMBS
  • shared method SetKeyGlobal(name as string, key as string)
• 64 constants

This class has no sub classes.

Blog Entries

• MBS Xojo Plugins, version 25.1pr1
• News from the MBS Xojo Plugins Version 25.0
• News from the MBS Xojo Plugins Version 24.4
• News from the MBS Xojo Plugins Version 23.3
• New in MBS Xojo Plugins in version 23.1
• MonkeyBread Software Releases the MBS Xojo Plugins in version 23.1
• LibXL Extras for Xojo
• New in the MBS Xojo Plugins Version 20.2
• Multithreaded plugin functions can increase speed of Xojo application
• Register MBS Xojo Plugins

Xojo Developer Magazine

• 20.5, pages 75 to 76: Create and Read Excel Spreadsheets, Using LibXL with Xojo by Stefanie Juchmes
• 20.5, pages 72 to 73: Create and Read Excel Spreadsheets, Using LibXL with Xojo by Stefanie Juchmes
• 16.1, page 10: News

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
  • Changed properties in XLAutoFilterMBS, XLBookMBS, XLFilterColumnMBS, XLFontMBS, XLFormatMBS and XLSheetMBS class to be visible in debugger.
• 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:

• XLRichStringMBS.Constructor(book as XLBookMBS)
• XLSheetMBS.CopySheet(dest as XLBookMBS, Options as XLCopyOptionsMBS = nil)

Some properties using for this class:

• XLAutoFilterMBS.Book as XLBookMBS
• XLConditionalFormatMBS.Book as XLBookMBS
• XLCorePropertiesMBS.Book as XLBookMBS
• XLFilterColumnMBS.Book as XLBookMBS
• XLFontMBS.Book as XLBookMBS
• XLFormatMBS.Book as XLBookMBS
• XLFormControlMBS.Book as XLBookMBS
• XLRichStringMBS.Book as XLBookMBS
• XLSheetMBS.Book as XLBookMBS
• XLTableMBS.Book as XLBookMBS

Some examples using this class:

• /XL/AutoFilter by Top10
• /XL/AutoFilter by Values
• /XL/AutoFilter Number Filter
• /XL/Convert
• /XL/Edit
• /XL/Extract
• /XL/Format
• /XL/Generate
• /XL/Invoice
• /XL/Invoice with Template/Invoice with Template

Some related classes:

• class DynaPDFMBS
• class XLAutoFilterMBS
• class XLCorePropertiesMBS
• class XLFilterColumnMBS
• class XLFontMBS
• class XLFormatMBS
• class XLFormControlMBS
• class XLRichStringMBS
• class XLSheetMBS
• class XLTableMBS

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

XLAutoFilterMBS   -   XLConditionalFormatMBS