MBS Xojo Developer Conference and Training
Join us from 3rd to 6th May 2017 in Berlin, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

XLBookMBS class

class, XL, MBS XL Plugin (XL), class XLBookMBS,
Plugin version: 11.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: Yes, Feedback.

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.

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