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.SetPictureWithScale

Sets a picture with pictureId identifier at position row and col with scale factor and offsets in pixels.

Parameters

Parameter	Description	Example	Flags
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
Row	The row for the cell. First row has index 0.	$row
Column	The column for the cell. First column has index 0.	$column
pictureId	The picture identifier number.	$pictureID
scale	The scale factor.	1.0
X	Relative offset.	0	Optional
Y	Relative offset.	0	Optional
pos	The positioning. 0 = Move and Size, 1 = Move, 2 = Absolute.	0	Optional

Result

Returns OK or error.

Description

Examples

Add a picture to excel sheet:

# add picture to file
Set Variable [$logoID; Value:MBS( "XL.Book.AddPictureContainer"; $book; Writing data::Logo)]
# position with size:
Set Variable [$r; Value:MBS( "XL.Sheet.SetPictureWithSize"; $book; $sheet; 2; 1; $logoID; 100; 100)]
# or with factor:
Set Variable [$r; Value:MBS( "XL.Sheet.SetPictureWithScale"; $book; $sheet; 2; 1; $logoID; .2)]

See also

• XL.Book.AddPictureContainer
• XL.Book.AddPictureFile
• XL.Book.SheetCount
• XL.LoadBook
• XL.Sheet.SetPictureWithSize

Example Databases

• XL/Writing data

Created 18th August 2014, last changed 27th July 2018

XL.Sheet.SetPaper   -   XL.Sheet.SetPictureWithSize

Feedback: Report problem or ask question.