2.5.13 insert_wks_to_layer

Brief Information

Insert worksheet as linked image into a graph or layout

Minimum Origin Version Required: 9.1 SR0

1.insert_wks_to_layer name:=Book1 table:=1;//Insert the active worksheet in Book1 to the current active graph/layout window as a table object

2.insert_wks_to_layer name:=[Book1]2!;//Insert sheet2 in Book1 to the current active graph/layout window as a bitmap

Display Name	Variable Name	I/O and Type	Default Value	Description
Name of Worksheet to Add	name	Input string	<unassigned>	Specify the worksheet name to be added into the graph
Name of GraphObject	ogname	Output string		This variable is read-only. It holds the name of the graph object which is inserted to the graph.
Insert as Table Object	table	Input int	0	Specify whether to insert the worksheet as a table object (set table = 1) or as a bitmap (set table = 0).

Display
Name

Variable
Name

I/O
and
Type

Default
Value

Description

Name of Worksheet to Add

name

Input

string

Specify the worksheet name to be added into the graph

Name of GraphObject

ogname

Output

string

This variable is read-only. It holds the name of the graph object which is inserted to the graph.

Insert as Table Object

table

Input

int

Specify whether to insert the worksheet as a table object (set table = 1) or as a bitmap (set table = 0).

This X-Function is used to insert a worksheet to the active graph layer or layout page, you can choose to insert it as a table object or as a bitmap.