2.2.3.18 insertImg

1 Menu Information
2 Brief Information
3 Command Line Usage
4 X-Function Execution Options
5 Variables
6 Description
7 Related X-Functions

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];

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name

Variable
Name

I/O
and
Type

Default
Value

Description

File Name

fname

Input

string

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

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

Cell

orng

Output

Range

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.