ADD

LANSA Integrator

previous page next page

ADD

The ADD command is used to add images, formulas and hyperlinks to an Excel document.

The ADD command must be preceded by an OPEN command with write mode.

Required

ADD -------- OBJECT ----------- *IMAGE ------------------------>

*FORMULA

*HYPERLINK

Optional

>-- SHEET ------------ sheet1 ------------------------|

value

Keywords

OBJECT

The type of object to add to the document *IMAGE, *FORMULA, or *HYPERLINK.

A value of *IMAGE is used to add a image to a specified sheet.

A value of *FORMULA is used to add a formula to a specified sheet.

A value of *HYPERLINK is used to add a .hyperlink to a specified sheet.

SHEET

A specific sheet name can be entered otherwise the default value of sheet1 will be used.

Required

ADD -------- OBJECT ----------- *IMAGE ------------------------>

>-- FILE ------------- value ------------------------->

>-- R1C1 ------------- n,n --------------------------->

Optional

>-- R2C2 ------------- n,n --------------------------->

>-- ANCHOR ----------- *MOVE -------------------------|

*MOVESIZE

*NOMOVESIZE

Keywords

OBJECT	*IMAGE to add an image to the specified sheet.
SHEET	A specific sheet name can be entered otherwise the default value of sheet1 will be used.
FILE	The path to the PNG image file.
R1C1	The top-left cell where the image is added.
R2C2	This keyword is optional and specifies the bottom-right cell of the rectangle formed with the value of R1C1. If not value is specified then the images spans one cell.
ANCHOR	This keywords specifies how the image moves and sizes when column is sized. The defaulr value is *MOVESIZE.

Required

ADD -------- OBJECT ----------- *FORMULA ---------------------->

>-- FORMULA ---------- value ------------------------->

>-- R1C1 ------------- n,n ---------------------------|

Keywords

OBJECT	*FORUMLA to add a formula to the specified sheet.
SHEET	A specific sheet name can be entered otherwise the default value of sheet1 will be used.
FORMULA	Excel formula.
R1C1	The cell where the formula is to be added. If a cell format is defined, then this format is used when creating the cell formula.

Required

ADD -------- OBJECT ----------- *HYPERLINK -------------------->

>-- URL -------------- value ------------------------->

>-- R1C1 ------------- n,n --------------------------->

Optional

>-- R2C2 ------------- n,n --------------------------->

>-- LABEL ------------ value -------------------------|

Keywords

OBJECT	*HYPERLINK to add a hyperlink to the specified sheet.
SHEET	A specific sheet name can be entered otherwise the default value of sheet1 will be used.
URL	The hyperlink destination.
R1C1	The top-left cell where the hyperlink is added.
R2C2	This keyword is optional and specifies the bottom-right cell of the rectangle formed with the value of R1C1. If not value is specified then the hyperlink spans one cell.
LABEL	Hyperlink description.

Required

ADD -------- OBJECT ----------- *HYPERLINK -------------------->

>-- R1C1 ------------- n,n --------------------------->

>-- SHEET2 ----------- value ------------------------->

>-- R2C2 ------------- n,n --------------------------->

Optional

>-- LABEL ------------ value -------------------------|

Keywords

OBJECT	*HYPERLINK to add a hyperlink to the specified sheet.
SHEET	A specific sheet name can be entered otherwise the default value of sheet1 will be used.
R1C1	The cell where the hyperlink is added.
SHEET2	The hyperlink sheet destination.
R2C2	The hyperlink cell destination.
LABEL	Hyperlink description.

previous page start next page