# 2.5.9 g2w

## Brief Information

Move graphs to worksheet cells in an mxn arrangement

## Command Line Usage

 

1. g2w option:=recursive; 

2. g2w option:= recursive cols:=4; 

3. g2w embed:=link; 

## Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Output Worksheet ow

Output

Worksheet

<new>

Specifies the worksheet which the graphs will be moved into. See the syntax here.

Move Graphs From option

Input

int

folder

Specifies the graphs to be moved.
Option list

• page:Active Page
Moves all graphs in the active page into the target worksheet.
• folder:All in Active Folder
Moves all graphs in the active folder, not including those in its subfolders, into the target worksheet.
• recursive:All in Active Folder (Recursive)
Moves all graphs in the active folder, including those in the subfolders, into the target worksheet.
• open:All in Active Folder (Open)
Moves all open graphs in the active folder into the target worksheet. All hidden graphs are excluded.
• embed:All in Active Folder (Include Embedded)
Moves all open graphs in the active folder, including those that are embedded in worksheets, into the target worksheet. Note: this option is only available when the Embed variable is set to Linking.
• project:All in Project
Moves all graphs in the project.
• specified:Specified
Moves the specified graphs into the target worksheet. The Graphs box will be enabled.

Graphs graphs

Input

string

If the Move Graphs From variable is set to Specified, user can use this text box to enter the names of the graphs to be moved. In this case, the browse button to the right of this text box becomes enabled and you can use it to browse for the graphs to be moved. However, if other options are selected for the Move Graphs From variable, this textbox will be read-only. You can see the names of the graphs that will be moved, but you cannot edit the content of this text box.

Graph Arrangement arrange

Input

int

nm

Specifies how to arrange the graphs and their names
Option list

• Vertical:Vertically
Two columns in the target worksheet will be used. The name so the graphs will be put in the first column. And the graphs will be put in the second column.
• nm:N*M Panel
N columns in the target worksheet will be used, where N is specified by the cols variable. The name of the graph will be put in the cell above the cell where the graph is embedded.

Columns(N) cols

Input

double

3

This variable is available only when the arrange variable is set to NMPanel. It specifies the number of columns that will be used to arrange the graphs.

Embed embed

Input

int

embed

Specifies whether or not to embed the graphs. If the graphs are not embedded, they will be linking to the worksheet instead.
Option list

• Embed:Embedding
Embeds the graphs into the target workbook.