Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items Next items

XLBookMBS.LoadPartially(path as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Loads a file only with specified sheet index and row range into memory.
Notes: Returns false if error occurs or true on success.. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadPartiallyUsingTempFile(path as folderitem, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, TempFile as folderitem) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Loads a file only with specified sheet index and row range into memory.
Notes:
Specify a temporary file for reducing memory consumption.
Returns false if error occurs or true on success.. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadPartiallyUsingTempFile(path as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, TempFile as String) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Loads a file only with specified sheet index and row range into memory.
Notes:
Specify a temporary file for reducing memory consumption.
Returns false if error occurs or true on success.. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadRaw(data as MemoryBlock) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 14.4 Yes Yes Yes Yes No
Function: Loads a xls-file from user's memory buffer.
Notes:
Returns false if error occurs. Get error info with errorMessage property.

With the constructor of the XLBookMBS object you decide if you want to load XML format or older binary format. If the format of the book object doesn't match the file, it will fail.

Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadRaw(data as string) 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: Loads a xls-file from user's memory buffer.
Notes:
Returns false if error occurs. Get error info with errorMessage property.

With the constructor of the XLBookMBS object you decide if you want to load XML format or older binary format. If the format of the book object doesn't match the file, it will fail.

Loading a file into the book object clears existing formats, sheets and fonts from previous book. You can recreate the ones you need or search them in the existing formats, fonts or sheets.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadRawMT(data as MemoryBlock) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.5 Yes Yes Yes Yes No
Function: Loads from memoryblock.
Notes:
Same as the other method without MT in name, except:
The work is performed on a preemptive thread, so this function can yield time to other Xojo (Real Studio) threads. For best user experience run this command on a Xojo (Real Studio) thread, so your GUI stays responsive.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadRawMT(data as string) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.5 Yes Yes Yes Yes No
Function: Loads from string.
Notes:
Same as the other method without MT in name, except:
The work is performed on a preemptive thread, so this function can yield time to other Xojo (Real Studio) threads. For best user experience run this command on a Xojo (Real Studio) thread, so your GUI stays responsive.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadRawPartially(data as MemoryBlock, sheetIndex as Integer, firstRow as Integer, lastRow as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Loads a file from user's memory buffer.
Notes:
data: Data buffer
sheetIndex: loads a file only with specified sheet index, -1 loads all sheets
firstRow: the first row of loaded range, -1 loads all rows until lastRow
lastRow: the last row of loaded range, -1 loads all rows after firstRow.
Returns false if error occurs or true on success. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadRawPartially(data as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Loads a file from user's memory buffer.
Notes:
data: Data buffer
sheetIndex: loads a file only with specified sheet index, -1 loads all sheets
firstRow: the first row of loaded range, -1 loads all rows until lastRow
lastRow: the last row of loaded range, -1 loads all rows after firstRow.
Returns false if error occurs or true on success. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadUsingTempFile(path as folderitem, TempFile as folderitem) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Loads an entire file into memory.
Notes:
Specify a temporary file for reducing memory consumption.
Returns false if error occurs or true on success. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.LoadUsingTempFile(path as string, TempFile as String) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Loads an entire file into memory.
Notes:
Specify a temporary file for reducing memory consumption.
Returns false if error occurs or true on success. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.MoveSheet(SourceIndex as integer, DestIndex as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.2 Yes Yes Yes Yes No
Function: Takes a sheet with SourceIndex and insert it in front of a sheet with DestIndex.
Notes: Returns false if error occurs and true on success.

Feedback, Comments & Corrections

XLBookMBS.PackColor(ColorValue as color) 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: Packs red, green and blue components in color type.

See also:

Feedback, Comments & Corrections

XLBookMBS.PackColor(red as Integer, green as Integer, blue as Integer) 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: Packs red, green and blue components in color type.

See also:

Feedback, Comments & Corrections

XLBookMBS.PackDate(d as date) as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Packs date and time information into double type.

See also:

Feedback, Comments & Corrections

XLBookMBS.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
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Packs date and time information into double type.

See also:

Feedback, Comments & Corrections

XLBookMBS.Picture(index as Integer, byref data as string) 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 picture at position index in memory buffer.
Notes:
Parameters:
index: position in the workbook
data: reference to buffer

Returns type of picture. See PictureType* constants.

Feedback, Comments & Corrections

XLBookMBS.PictureCount 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 pictures in this workbook.

Feedback, Comments & Corrections

XLBookMBS.RefR1C1 as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Whether the R1C1 reference mode is active.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

XLBookMBS.RgbMode as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Whether the RGB mode is active. Used for xlsx format only.
Notes:
true - RGB mode, false - Index mode (default).
In RGB mode use colorPack() and colorUnpack() methods for getting/setting colors. Used for xlsx format only.
(Read and Write computed property)

Feedback, Comments & Corrections

XLBookMBS.Save(path as folderitem) 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: Saves current workbook into xls-file.
Notes: Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.

See also:

Feedback, Comments & Corrections

XLBookMBS.Save(path as folderitem, UseTempFile as Boolean) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Saves current workbook into the file.
Notes:
Use a temporary file for reducing memory consumption.
Returns false if error occurs or true on success. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.Save(path as string) 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: Saves current workbook into xls-file.
Notes: Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.

See also:

Feedback, Comments & Corrections

XLBookMBS.Save(path as string, UseTempFile as Boolean) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.3 Yes Yes Yes Yes No
Function: Saves current workbook into the file.
Notes:
Use a temporary file for reducing memory consumption.
Returns false if error occurs or true on success. Get error info with errorMessage function.

See also:

Feedback, Comments & Corrections

XLBookMBS.SaveMT(path as folderitem) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.5 Yes Yes Yes Yes No
Function: Saves document to file on disk.
Notes:
Same as the other method without MT in name, except:
The work is performed on a preemptive thread, so this function can yield time to other Xojo (Real Studio) threads. For best user experience run this command on a Xojo (Real Studio) thread, so your GUI stays responsive.

See also:

Feedback, Comments & Corrections

XLBookMBS.SaveMT(path as string) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.5 Yes Yes Yes Yes No
Function: Saves document to file on disk.
Notes:
Same as the other method without MT in name, except:
The work is performed on a preemptive thread, so this function can yield time to other Xojo (Real Studio) threads. For best user experience run this command on a Xojo (Real Studio) thread, so your GUI stays responsive.

See also:

Feedback, Comments & Corrections

XLBookMBS.SaveRaw(byref data as MemoryBlock) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 14.4 Yes Yes Yes Yes No
Function: Saves a xls-file to internal memory buffer.
Notes: Returns false if error occurs. Get error info with errorMessage property.

See also:

Feedback, Comments & Corrections

XLBookMBS.SaveRaw(byref data as string) 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: Saves a xls-file to internal memory buffer.
Notes: Returns false if error occurs. Get error info with errorMessage property.

See also:

Feedback, Comments & Corrections

XLBookMBS.SaveRawMT(byref data as MemoryBlock) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.5 Yes Yes Yes Yes No
Function: Saves document to memoryblock.
Notes:
Same as the other method without MT in name, except:
The work is performed on a preemptive thread, so this function can yield time to other Xojo (Real Studio) threads. For best user experience run this command on a Xojo (Real Studio) thread, so your GUI stays responsive.

See also:

Feedback, Comments & Corrections

XLBookMBS.SaveRawMT(byref data as string) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 17.5 Yes Yes Yes Yes No
Function: Saves document to string.
Notes:
Same as the other method without MT in name, except:
The work is performed on a preemptive thread, so this function can yield time to other Xojo (Real Studio) threads. For best user experience run this command on a Xojo (Real Studio) thread, so your GUI stays responsive.

See also:

Feedback, Comments & Corrections

Previous items Next items

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





Links
MBS Xojo Plugins