Monkeybread Software - MBS FileMaker Plugin: XL.Book.AddPictureFile

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

XL.Book.AddPictureFile

Adds a picture to the workbook.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
XL	3.5	Yes	Yes	Yes	Yes	Yes

MBS( "XL.Book.AddPictureFile"; bookRef; filepath ) More

Parameters

Parameter Description Example

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"

Parameter	Description	Example
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"

Result

Returns image number or error.

Description

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.

Blog Entries

MBS FileMaker Plugin, version 8.2pr2

Release notes

Version 8.2
- Fixed parameter count check for XL.Book.AddPictureFile.

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

XL.Book.AddPictureContainer - XL.Book.AddSheet