Monkeybread Real Studio plugin - The class XLBookMBS

Meet us at at Real World in Orlando, Florida.

Platforms to show: All Mac Windows Linux Cross-Platform

The class XLBookMBS

class XLBookMBS
MBS Real Studio XL Plugin (XL),

class, XL, MBS Real Studio 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.
Notes:
The MBS 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:
https://www.plimus.com/jsp/redirect.jsp?contractId=2284940&referrer=MonkeybreadSoftware

property Handle as Integer
method ActiveSheet as integer
method AddCustomNumFormat(customNumFormat as string) as integer
method AddFont(initFont as XLFontMBS = nil) as XLFontMBS
method AddFormat(initFormat as XLFormatMBS = nil) as XLFormatMBS
method AddPicture(path as folderitem) as integer
method AddPicture(path as string) as integer
method AddPictureData(data as string) as integer
method AddSheet(name as string = "", initSheet as XLSheetMBS = nil) as XLSheetMBS
shared method available as boolean
method BiffVersion as integer
method Constructor(xml as boolean = false)
method CustomNumFormat(fmt as integer) as string
method DefaultFont(byref fontSize as integer) as string
method DelSheet(index as integer) as boolean
method ErrorMessage as string
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 LoadRaw(data as string) 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 Picture(index as integer, byref data as string) as integer
method PictureCount as integer
method RefR1C1 as integer
method RgbMode as boolean
method Save(path as folderitem) as boolean
method Save(path as string) as boolean
method SaveRaw(byref data as string) as boolean
method SetDefaultFont(fontName as string, fontSize as integer)
method SetKey(name as string, key as string)
shared method SetKeyGlobal(name as string, key as string)
method SetLocale(locale as string)
method Sheet(index as integer) as XLSheetMBS
method SheetCount as integer
method Sheets as XLSheetMBS()
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

Picture Format Constants

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

This class has no sub classes.

Some examples which use this class:

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

Links
MBS Real Studio PDF Plugins - Nachhilfe in Wassenach