Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 10.1 10.2 10.3 10.4 10.5 11.0 11.1 11.2 11.3 11.4 Statistic FMM Blog
Loads a Excel file partially.
|XL||8.0||✅ Yes||✅ Yes||✅ Yes||✅ Yes||✅ Yes|
|Data||Either text with file path or container value which contains the Excel file data.||"C:\test\test.xls"|
|SheetIndex||The index of the sheet to delete. This number ranges from 0 to XL.Book.SheetCount-1.||0|
|FirstRow||The first row index to load.
Starts with 0 for first one.
|LastRow||The last row index to load.||100|
|Type||Which type of file this is.
Pass 0 for unknown, 1 to try xml format (xlsx) and 2 to try binary format (xls).
Returns book reference number on success.
DescriptionLoads a Excel file partially.
Loads a file only with specified sheet index and row range into memory.
Works with both XML based xlsx files and older xls files.
Book reference numbers are starting at 19000 and counting up for each new book.
Try partial loading:
- Version 8.0
- Added XL.LoadBookPartially function.
Created 10th January 2018, last changed 20th March 2018
Feedback: Report problem or ask question.
MBS Xojo Plugins