1.1.22 OA_PlotWksCols


Description

Plot a range of cells from a Worksheet to a GraphLayer. Only XY type of plots are supported with this sub-VI.

You need to assign the proper column designations (Column.Type) in the worksheet before adding them to a graph layer. Origin make the plots in same way as you would when you select these columns to plot them. See LabVIEW:OA_Col-Setting on how to setup column designations.

Minimum Version Required: Origin 8.5 SR0

Connector Pane

OA PlotWksCols CP.png

Controls and Indicators

CI ref c.jpg Origin.GraphLayer in is a reference to Origin.GraphLayer.
CI ref c.jpg Origin.Worksheet in is a reference to Origin.Worksheet.
CI err c.jpg error in contains error information that occur before this VI or function runs.
CI num c.jpg r1 is the first row of the range to be plotted. The default value is 0.
CI num c.jpg r2 is the last row of the range to be plotted. The default value is -1, which indicates the end of data.
CI num c.jpg c1 is the first column of the range to be plotted. The default value is 0.
CI num c.jpg c2 is the last column of the range to be plotted.The default value is -1, which indicates the end of data.
CI num c.jpg Plot Type is one of the XY plot type that Origin supports, such as
200 = line
201 = scatter
202 = line + symbol

Default value is 200.

CI ref i.jpg Origin.GraphLayer Out is the refnum of the GraphLayer.
CI ref i.jpg Origin.Worksheet Out is the refnum of the Worksheet.
CI err i.jpg error out contains error information.
CI ref i.jpg Origin.DataPlot is the refnum of Dataplot. It is a invalid refnum if the plot failed to be added.