Contents |
Add woksheet(s)/matrix(es) to specified worksheet/Matrix book.
Minimum Origin Version Required: 8.0 SR6
1.addsheet book:=Book1 fname:=templates\analysis\Assays.ogw index:=2 active:=1 oname:=aa
2.addsheet book:=book1 fname:=origin.otw oname:=bb
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Book to Add Sheet | book |
Input Page | | Specify the workbook or matrix book to add worksheet or matrix. |
| Template Name | fname |
Input string | | Specify the template which is used to create new sheet(s). It can be a worksheet template (*.OTW), a matrix book templates (*.OTM), a workbook file (*.OGW) or a matrix file (*.OGM). If template file name does not include full path, we assume it is under <Origin Installation Folder> or <Origin User Folder>. |
| Sheet Index in Template | index |
Input int | | Specify which sheet of the template to be added. Note that the index of the first sheet is 1. If 0 is used, all sheets in the template will be added. |
| Activate Added Sheet | active |
Input int | | Specify whether to activate the added sheet |
| Name of Added Sheet | oname |
Output string | | Specify a variable to save the name of added sheet. |
The addsheet function is used to add worksheet(s) or matrix(es) to specified workbook or Matrix book with a designated template. You can choose to add one sheet or all sheets in the template.