2.2.23 newtable


Contents

Menu Information

File: New: Worksheet: New Data Table

Brief Information

Create a new worksheet or data table by selecting a table type and other settings

Additional Information

Minimum Origin Version Required: 2026b

Command Line Usage

1. newtable type:=free xy:=XY* cols:=10;

2. newtable type:=x names:="Event;Group" xt:=1 xname:=ID;

3. newtable type:=one names:="Event;Group" xt:=1;

4. newtable names:="Event;Group" xname:=ID;

5. newtable type:=con;

6. newtable type:=suv names:="Event;Group" xt:=1 etime:=Months;

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
Table Type type

Input

int

3
 Specify the table type for the new created sheet. Option list:
  • free:Free Form (Worksheet) {0}
  • x:XY {1}
  • one:Column (One Way) {2}
  • two:Grouped (Two Way) {3}
  • con:Contingency {4}
  • suv:Survival {5}

Refer to this page for more information on table type.

Data Format sum

Input

int

0
 Specify data format. Available when Data Type = XY. Option list:
  • raw:Raw Data {0}
  • mean:Summary (Mean) {1}
  • median:Summary (Median) {2}
Statistics err

Input

int

0
 Specify statistics value for data and error. Available when Data Format = Summary (Mean) or Summary (Median).
Set Column Designatioins xy

Input

string

XY
 Specifies the column designations for all data columns. For example, if you enter XY, the plot designations of the columns will be set to the repeating pattern of "XYXYXY". In this string, each character corresponds to the designation of one column, as shown below:

'X' - X
'Y' - Y
'Z' - Z
'E' - Y Error
'L' - Label
'M' - X Error
'N' - Disregard

Number of Columns cols

Input

int

2
 Specify the number of columns for the new worksheet. Available for Table Type = Free Form.
Number of Groups groups

Input

int

2
 Specify the number of groups. Available for Table Type = XY or Grouped (Two Way).
Group Names (separated by semicolons) names

Input

string

Enter semicolon-separated names for groups.
Row Title xt

Input

int

0
 Check to add a Text column for row labels. Option list: 0=false, 1=true
X Error xerr

Input

int

0
 Check to add an error bar column for X. Available for Table Type = XY. Option list: 0=false, 1=true
Number of Subgroup subgroups

Input

int

0
 Specify the number of subgroup.
Subgroup Names subnames

Input

string

Enter the names of subgroups.
count

Input

int

2
 ".
X Title xname

Input

string

Enter the X title.
Column Categories bnames

Input

string

Success; Failure
 Enter semicolon-separated labels for the second categorical variable. Available for Table Type = Contingency.
Elapsed Time in etime

Input

string

Days
 Change the unit, Months, Years, etc.

Description

This X-Function is used to create new Origin classic worksheet or Data Table.

Related X-Functions

newsheet, addsheet, newbook