Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items

XLBookMBS.SetDefaultFont(fontName as string, fontSize as Integer)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Sets a default font name and size for this workbook.

Feedback, Comments & Corrections

XLBookMBS.SetKey(name as string, key as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Sets customer's license key.
Notes:
Call this once for each XLBookMBS object and before you read or write data.

If you have keys for more than one platform, please use #if condition to make sure you pass right key for current platform.

Feedback, Comments & Corrections

XLBookMBS.SetKeyGlobal(name as string, key as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 18.3 Yes Yes Yes Yes No
Function: Private method to avoid you call this on an object.
Notes:
Please call shared method in app.open.
Because if you make a new object and set key, it's too late.

See also:

Feedback, Comments & Corrections

XLBookMBS.SetLocale(locale as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Sets the locale.
Example:
dim book as new XLBookMBS(false)
book.SetLocale "en_US.UTF-8"
Notes: Sets the locale for this library. It has no effect for unicode projects.

Feedback, Comments & Corrections

XLBookMBS.Sheet(index as Integer) as XLSheetMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Gets the sheet with specified index.
Notes: Returns NULL if error occurs. Get error info with XLBookMBS.ErrorMessage property.

Feedback, Comments & Corrections

XLBookMBS.SheetCount as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Returns a number of sheets in this book.

Feedback, Comments & Corrections

XLBookMBS.Sheets as XLSheetMBS()
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Returns array with all sheets.
Example:
Function SheetByName(book as XLBookMBS, name as string) As XLSheetMBS
dim sheets() as XLSheetMBS = book.Sheets
for each s as XLSheetMBS in sheets
if s.Name = name then
Return s
end if
next
End Function

Feedback, Comments & Corrections

XLBookMBS.SheetType(index as Integer) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 13.1 Yes Yes Yes Yes No
Function: Queries type of the sheet.

Feedback, Comments & Corrections

XLBookMBS.UnpackColor(ColorValue as Integer) as color
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Unpacks color type to red, green and blue components.

See also:

Feedback, Comments & Corrections

XLBookMBS.UnpackColor(ColorValue as Integer, byref red as Integer, byref green as Integer, byref blue as Integer)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Unpacks color type to red, green and blue components.

See also:

Feedback, Comments & Corrections

XLBookMBS.UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Unpacks date and time information from double type.
Notes: Returns false if error occurs.

See also:

Feedback, Comments & Corrections

XLBookMBS.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
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Unpacks date and time information from double type.
Notes: Returns false if error occurs.

See also:

Feedback, Comments & Corrections

XLBookMBS.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
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Unpacks date and time information from double type.
Notes: Returns false if error occurs.

See also:

Feedback, Comments & Corrections

Previous items

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




Links
MBS Xojo PDF Plugins