Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

XLBookMBS class

Type Topic Plugin Version macOS Windows Linux Console & Web iOS
class XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The central class for a workbook.
The MBS Xojo (Real Studio) 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:

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

Feedback, Comments & Corrections

Picture Format Constants

Constant Value Description
PictureTypeDIB 4 DIB format
PictureTypeEMF 5 EMF format
PictureTypeError &hFF Error. Check XLBookMBS.ErrorMessage method.
PictureTypeGIF 2 GIF format.
PictureTypeJPEG 1 JPEG format
PictureTypePICT 6 Mac PICT format.
PictureTypePNG 0 PNG format
PictureTypeTIFF 7 TIFF format
PictureTypeWMF 3 WMF format

Sheet Types

Constant Value Description
SheetTypeChart 1 Sheet is a chart.
SheetTypeSheet 0 This is a normal sheet.
SheetTypeUnknown 2 Type is unknown.

This class has no sub classes.

Some methods using this class:

Some properties using for this class:

Some examples which use this class:

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

XLAutoFilterMBS   -   XLFilterColumnMBS

MBS Xojo blog