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.2   8.3   8.4   8.5   9.0   9.1   9.2   9.3   9.4   9.5    Statistic  


Adds a picture to the workbook.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 3.5 Yes Yes Yes Yes Yes
MBS( "XL.Book.AddPictureFile"; bookRef; filepath )   More


Parameter Description Example value
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
filepath The native file path to the image file to include. "c:\test.jpg"


Returns image number or error.


Adds a picture to the workbook.
Returns a picture identifier. Supports BMP, DIB, PNG, JPG and WMF picture formats.
Use picture identifier with XL_Sheet_setPicture function.

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.

See also

Blog Entries

Release notes

Created 18th August 2014, last changed 5th September 2014

XL.Book.AddPictureContainer   -   XL.Book.AddSheet

Feedback: Report problem or ask question.

MBS Xojo Chart Plugins