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.Sheet.GetPicture

Returns a workbook picture index at position index in worksheet.

Component Version macOS Windows Linux Server FileMaker iOS SDK
XL 3.5 Yes Yes Yes Yes Yes
MBS( "XL.Sheet.GetPicture"; bookRef; sheetIndex; Index; Selector )   More

Parameters

Parameter Description Example
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
Index The image index from 0 to XL.Sheet.PictureCount-1. $index
Selector Which value to return. Can be id, rowTop, colLeft, rowBottom, colRight, width, height, offsetx or offsety. "id"

Result

Returns value or error.

Description

Returns a workbook picture index at position index in worksheet.
Output parameters:
(rowTop, colLeft) - top left position of picture;
(rowBottom, colRight) - bottom right position of picture;
width - width of picture in pixels;
height - height of picture in pixels;
offsetX - horizontal offset of picture in pixels;
offsetY - vertical offset of picture in pixels.
Use XL.Book.GetPicture for extracting binary data of picture by workbook picture index.

See also

Created 18th August 2014, last changed 17th October 2017


XL.Sheet.GetPaper   -   XL.Sheet.GetPrintArea

Feedback: Report problem or ask question.



Links
MBS Xojo Plugins

Start Chat