ADD

LANSA Integrator

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.