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
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:
- /XL/Invoice with Template for Web/Invoice with Template for Web
- /XL/Invoice with Template/Invoice with Template
- /XL/Invoice with Template for Web/Invoice with Template
- /XL/Writing data
- /XL/Performance
- /XL/Invoice
- /XL/Invoice xml
- /XL/Generate
- /XL/Format
- /XL/Extract
- /XL/Edit
- /XL/Custom Number Formats
The items on this page are in the following plugins: MBS Real Studio XL Plugin.
Links
MBS Real Studio PDF Plugins - Nachhilfe in Wassenach