XLBookMBS.SetKeyGlobal(name as string, key as string)   Private

Please call shared method in app.open.
Because if you make a new object and set key, it's too late.

See also:

• SetKeyGlobal(name as string, key as string)

XLBookMBS.SetLocale(locale as string)

dim book as new XLBookMBS(false)
book.SetLocale "en_US.UTF-8"

Sets the locale for this library. It has no effect for unicode projects.

XLBookMBS.Sheet(index as Integer) as XLSheetMBS

Returns nil if error occurs. Get error info with XLBookMBS.ErrorMessage property.

XLBookMBS.SheetCount as Integer

Some examples using this method:

• /XL/Edit

XLBookMBS.Sheets as XLSheetMBS()

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

Some examples using this method:

• /XL/Edit
• /XL/Extract
• /XL/List Hyperlinks

XLBookMBS.SheetType(index as Integer) as Integer

XLBookMBS.UnpackColor(ColorValue as Integer) as color

See also:

• UnpackColor(ColorValue as Integer, byref red as Integer, byref green as Integer, byref blue as Integer)

XLBookMBS.UnpackColor(ColorValue as Integer, byref red as Integer, byref green as Integer, byref blue as Integer)

See also:

• UnpackColor(ColorValue as Integer) as color

XLBookMBS.UnpackDate(Value as Double) as date

Returns nil if error occurs.

See also:

• UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer) as boolean
• 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
• 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

Some examples using this method:

• /XL/Extract

XLBookMBS.UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer) as boolean

Returns false if error occurs.

See also:

• UnpackDate(Value as Double) as date
• 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
• 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

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

Returns false if error occurs.

See also:

• UnpackDate(Value as Double) as date
• UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer) as boolean
• 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

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

Returns false if error occurs.

See also:

• UnpackDate(Value as Double) as date
• UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer) as boolean
• 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

XLBookMBS.UnpackDateTime(Value as double) as dateTime

Returns nil if error occurs.