Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items

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 FileMaker blog