|Examples||Mac & Win||Server||Client||Guides||Statistic||FMM||Blog||Deprecated||Old|
Initializes the XL library by loading it.
|XL||2.9||✅ Yes||✅ Yes||✅ Yes||✅ Yes||✅ Yes|
|LibPath||Native path to the DLL on Windows or Dylib file on MacOS.
Can be empty for default file name with file in same folder as plugin.
|LicenseName||The name of your libXL license.||""||Optional|
|LicenseKey||The license key of your libXL license.||""||Optional|
Returns OK on success.
DescriptionInitializes the XL library by loading it.
You can keep the library in a database field and export it at runtime to a known location and load it from there.
If you have no license yet, you can test this function by passing empty strings for name and key. If you have a license key, please pass it and we store it for unlocking the library later when loading/creating a book.
For getting a license key, please visit the libXL website:
Starting with version 4.4, you can pass just the filename of library and the plugin finds it in the Extensions folder or in FileMaker's application folder.
Windows error 193 means that 64-bit FileMaker tried to load 32-bit library or 32-bit FileMaker tried to load 64-bit library. The bit level must match between app and library. For macOS the error message will tell you about wrong architecture.
Starting version 9.5, the plugin will look into the same folder for the DLL as the plugin resides. And we still look for 32/64 suffixes to DLL name. If no name is provided, we look for libxl.dll/dylib/so files.
If you get a crash here on MacOS, please check if crash report says Code Signature Invalid. Then you may need to code sign the dylib yourself to match the code signature of your runtime application. The dylib from MBS is normally code signed already and should work as is.
- If you get error 193 on Windows, you may have the wrong architecture. e.g. you got 32-bit, but you need 64-bit or vice versa.
- If you got a libxl.dylib on macOS, that is no code signed, you will get back an error message, that the file is not allowed to load (disallowed by OS policy).
- If you got a libxl.dylib on macOS, that is not notarized, you may see a gate keeper dialog telling you the library was not searched for malware and the file can't be loaded (disallowed by OS policy).
- If you got a libxl.so or libxl.dylib for the wrong CPU architecture, the function will return an error with e.g. saying you need x86, but have arm code or vice versa.
- if you managed to load a libxl.dylib with a broken code signature, you may see a crash when the plugin calls CreateBook function reporting a broken code signature.
- If the file path is wrong, the macOS and Linux plugins report an error message about that. On Windows you may just get error 126, which means "module not found".
- If the file is shorted than expected on macOS, you get an error with a message like this: slice 1 extends beyond end of file.
- If you overwrite the libxl.dylib file after loading it, you may get crashes with broken code signature, if old and new file are not identical.
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.
Initialize when needed:
Initialize with license key on Windows with Server:
Initialize automatically and look in same folder as plugin for the DLL/dylib/so file:
Register LibXL for MBS Plugin
Init with automatic picking of library name:
- Version 11.2
- Changed XL.Initialize to accept empty path and pick the file name automatically per platform.
- Version 9.5
- Version 8.0
- XL/Change Column Names
- XL/Edit Sheet
- XL/Export records
- XL/Sheet with colored text
- XL/Writing data
- Tips and tricks with MBS
- Read And Write Excel Files With FileMaker
- MBS FileMaker Plugin, version 11.2pr1
- MBS FileMaker Plugin, version 9.5pr6
- How to use XL functions with MBS FileMaker Plugin
This function checks for a license.
Created 18th August 2014, last changed 25th October 2023