2.2.3.21 insertVar


Menu Information

Right-click context menu of worksheet cell: Insert Variables...

Brief Information

Open the Insert Variables dialog

Additional Information

X-Function not designed for Auto GetN Dialog.

Command Line Usage

1. insertVar cell:=[Book1]Sheet1!col(A)[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
Top Left Cell cell

Input

Range

<active>
Specify the destination of inserted variable.

Description

After the importing is done, there are some metadata that are saved in the Workbook Organizer and column property's user tree tab. Also, you can add variables in the user trees in the Workbook Organizer. With this X-Function, the metadata and user-created variables can be inserted into a specify worksheet cell.

You can insert multiple variables at a time. If n variables are inserted, the destination cell will be used to hold the first variable. Then the cells below it will be used to show the 2nd to the nth variables.

Please see the details about the Insert Variables dialog, in the this user guide page.

Related X-Functions

insertArrow, insertGraph, insertImg, insertNotes, insertSparklines