Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 8.3   8.4   8.5   9.0   9.1   9.2   9.3   9.4   9.5   10.0    Statistic  


Loads a Excel file.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 2.9 Yes Yes Yes Yes Yes
MBS( "XL.LoadBook"; Data { ; Type } )   More


Parameter Description Example value
Data Either text with file path or container value which contains the Excel file data. "C:\test\test.xls"
Type Optional
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.


Loads a Excel file.
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.

This function requires a native path. Use Path.FileMakerPathToNativePath to convert a FileMaker path to a native path if required. If you like to have the user choose the path, you can use FileDialog functions.
For Server be aware that server has limited permissions and may not be able to access all files on a computer.


Load file from container with auto detect:

Set Variable [ $book; Value: MBS( "XL.LoadBook"; MyTable::myFileContainer; 0 ) ]

See also

Example Databases

Blog Entries

Release notes

Created 18th August 2014, last changed 3th January 2020

XL.IsInitialized   -   XL.LoadBookPartially

Feedback: Report problem or ask question.

MBS FileMaker blog