Add a new sheet to workbook or matrix book
1. newsheet name:="ASCII Data";
2. newsheet cols:=6 xy:="XYE";
3. newsheet labels:="This is 1st column|This is 2nd Column|This is 3rd Column";
4. newsheet book:=Book1 template:=fft;
5. newsheet n:="my test" c:=5 r:=1000 xy:=Y o:=sname$ a:=0;//5x1000 sheet without activating
Please refer to the page for additional option switches when accessing the x-function from script
Input
Page
Specifies the book to add a new sheet. The default is the active book.
string
Specifies the desired name for the new sheet.
Specifies the long names of the columns in the new sheet. If there are multiple columns, the long names should be separated with "|".
int
Specifies the number of columns in the new sheet.
Specifies the number of rows in the new sheet.
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 "YXYXY...". 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
Specifies the template that will be used for creating the new sheet.
If this variable is set to 1 and an existing sheet has the desired sheet name, the X-Function will not create a new sheet. If this variable is set to 0, a new sheet will be created even if a sheet with the desired name is found.
Specifies the name of the sheet to use when the template has multiple sheets.
Output
Specifies the output for the actual sheet name.
Specifies whether or not the new sheet is a matrix sheet. By default, this is set to false and this X-Function adds a workbook sheet.
Activate the new sheet.
The newsheet function adds a new sheet to a specified workbook/matrix book.
// New sheets can be created along with named columns // If the active window is not a Workbook, create one if( exist(%H) != 2 ) newbook; // Get the name of the active Workbook string name$ = page.name$; // Create an extra workbook to show that command can specify target book newbook; // Repeat this command 8 times // use:=0 will force enumeration of sheet names repeat 8 { newsheet book:=name$ name:="Week 1" labels:="Time|Monday|Tuesday|Wednesday|Thursday|Friday" rows:=24 xy:=XYYYYY active:=0 use:=0; } // Switch to the Workbook we were modifying win -a %(name$); // and make the fourth sheet we created active page.active$ = "Week 4";
newbook