# 2.2.3.62 wrow2label

## Brief Information

Promote worksheet data rows to label rows

## Command Line Usage

 

1. wrow2label longname:=1 unit:=2; 

2. wrow2label comment:=3 removerow:=0 showlabel:=0; 

## Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Worksheet To Set Label Value iw

Input

Worksheet

<active>

Specifies the input worksheet.

Row Index of Name name

Input

int

0

Specifies the index of the row that will be converted to short name.

Note that from Origin 2017 column Short Name is restricted to alphabetical order and it cannot be edited by default. So Row Index of Name option is hidden from GUI. If you want to rename column Short Names, you will need to go to the input workbook, uncheck Spreadsheet Cell Notation checkbox in the Properties tab of Window Properties dialog to enable editing column Short Name.

Row Index of Long Name longname

Input

int

0

Specifies the index of the row that will be converted to long name.

Row Index of Unit unit

Input

int

0

Specifies the index of the row that will be converted to unit.

Row Index of Comment comment

Input

int

0

Specifies the index of the row that will be converted to comment.

Remove Rows removerow

Input

int

1

Specifies whether to remove the converted rows.

Show Labels showlabel

Input

int

1

Specifies whether to force the label rows that have the converted information to be shown after this X-Function is executed.

## Description

This X-function is used to set the label value.