| Author |
 Topic  |
|
|
shafei
USA
49 Posts |
 Posted - 10/22/2012 : 7:22:16 PM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.6
Operating System:WIN 7
I have a template that would like to use it for several worksheets. One approach is to click on template library, choose a the template and click on "new window", and then copy data from existing worksheet and paste it in the template worksheet. However, what if I want to impose the template on the original worksheet, without any need to open a new worksheet and copying the data. Is there any way to do that? |
|
|
JessieWoo
China
46 Posts |
Posted - 10/23/2012 : 01:26:10 AM
|
Hi shafei,
I am not sure whether there are special settings in your template. If just settings on format, you can try using theme organizer to apply all format on the data worksheets.
Steps as follow:
1. Type @wef=1 in the script window, and press ENTER. (@wef is use to control Worksheet Edit Format menu showing or not, default value is 0)
2. Use the template to new a worksheet.
3. Right click on the empty space of the template worksheet, and then select "Edit Formatting…" from the context menu to bring up the Worksheet Theme Editor dialog.
4. Click "Save As…" to create a theme.
5. Open your data worksheets.
6. Press F7 or select "Tools: Theme Organizer".
7. In the Worksheet tab, select the new theme, and then select an option in "Apply Theme to". Click the "Apply Now" button to apply the theme to data worksheets.
Best Regard,
Jessie
Originlab Corp.
|
Edited by - JessieWoo on 10/23/2012 03:42:54 AM |
 |
|
|
shafei
USA
49 Posts |
Posted - 10/23/2012 : 01:36:37 AM
|
Hi Jessie,
It is not all about format. I have data in the first three column, that I use to calculate other parameters in fourth column, etc. Then I pick two column with error bars and fit polynomial. I then save the worksheet as a template.
I want to use this template to existing worksheets. Is there any way except copy and pasting data?
Thanks
Shoresh |
|
|
|
JessieWoo
China
46 Posts |
Posted - 10/23/2012 : 03:44:01 AM
|
Hi Shoresh,
In this case, you can try Batch Processing.
1. Save your template as analysis template. (File: Save Workbook as Analysis Template).
2. Select “File: Batch Processing…”.
3. Set “Analysis Template” as the template saved in step 1.
4. Set Data Source as “Use Existing XY Datasets”.
5. Click the right-triangle button at the end of Input section, select “Select column…” from the context menu.
6. Add the columns containing your data.
7. Click OK.
It will generate new workbooks with data processed using your template. You can open your data worksheets in one folder and then do batch processing in another folder, in case you want to quickly delete the data worksheets after processing.
The link below is a tutorial link for batch processing:
http://wiki.originlab.com/~originla/howto/index.php?title=Tutorial:Batch_Processing
Best Regard,
Jessie
Originlab Corp. |
Edited by - JessieWoo on 10/23/2012 03:47:05 AM |
|
|
| |
Topic |
|
|
|
Using template for existing worksheet