2.2.3.17 insertImg

Menu Information

Right-click context menu of worksheet cell: Insert Images from Files

Brief Information

Insert an image into a worksheet cell

Command Line Usage

1. insertimg fname:=c:\pepper.bmp;

2. insertimg fname:=c:\car.bmp orng:=[Book1]Sheet1!col(1)[2];

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
File Name fname

Input

string

<unassigned>
Specifies the images to be inserted. In the dialog, you can click the browse button on the right to select the images.
Resize Cell resizecell

Input

int

0
Specifies whether or not to resize the worksheet cell to fit the embedded or linked image.
Cell orng

Output

Range

<active>
Specifies the worksheet cell where the first image will be inserted. Other images, if any, will be inserted into the cells to its right or below.

See the syntax here.

Description

This X-Function inserts images from files into worksheet cells. When user double-clicks on the cell that has an inserted image, the image will be opened in a matrix window.

Note that images embedded in worksheet can be processed by the X-Functions which operate on images. When an inserted image is selected, the Image menu will be enabled.

Related X-Functions

insertGraph, insertNotes, insertSparklines, insertArrow, insertVar