Recently LibXL 5.2 was released and we include this update in our upcoming MBS Xojo XL Plugin.
Version 5.2.0 (2026-05-15)
- fixed the vulnerability CVE-2026-22184, updated zlib to the version 1.3.2
- added possibility to read data validations from xlsx files
- added possibility to remove filters from tables (xlsx)
- added the support for xlsx files in the Book::loadWithoutEmptyCells()
- fixed a bug with reading strings with incorrect character encoding in the CellReadText method on Linux/MacOSX (xls)
- fixed an issue with loading some xls files with message “read error: record id can’t be 0”
- fixed an issue with corrupting output files in the XLAutoFilterMBS SetSort function (xlsx)
- fixed the unhandled exception in the XLFormatMBS GetBorderLeftColor function (xlsx)
New methods in XLSheetMBS class:
- method DataValidation(index as Integer) as XLDataValidationValuesMBS
- method DataValidations as XLDataValidationValuesMBS()
- property DataValidationSize as Integer
- method IsAutoFilter as boolean
- method RemoveFilter
Version 5.1.0 (2026-01-20)
- added the property ErrorCode as Integer and XLBookMBS class for getting error codes
- added possibility to read conditional formats with the ConditionalFormats as XLConditionalFormatMBS()
- added possibility to remove conditional formattings with the RemoveConditionalFormatting(index as Integer) as Boolean
- added possibility to clear all data from a workbook with the method Clear
- fixed a bug with decrypting password-protected workbooks for the 32-bit version of the library
- fixed an issue that caused a crash when using an empty password
New functions:
- method Clear
- method ConditionalFormats as XLConditionalFormatMBS()
- method ConditionalFormat(index as integer) as XLConditionalFormatMBS
- property ConditionalFormatSize as Integer
- method ConditionalFormattings as XLConditionalFormattingMBS()
- method ConditionalFormatting(index as integer) as XLConditionalFormattingMBS
- method RemoveConditionalFormatting(index as Integer) as Boolean
- property ConditionalFormatSize as Integer
LibXL is a powerful library to create, read, edit and write Excel documents in older and newer Excel file formats and without the need to install Microsoft Excel. It allows the developer to automate a lot of tasks related to Excel spreadsheets within your solution or application.
Learn more on our LibXL for Xojo pages.