The Origin Forum
File Exchange
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 New Analysis Sheet Creation

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Drbobshepherd Posted - 06/21/2012 : 12:05:41 PM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 8.6.0 SR3
Operating System: Windows XP

I am trying to add a new sheet to my workbook, using one of my analysis templates, but Origin won't let me.

In my case, the template is named TimeAtAlt.ogw. It is a workbook with one worksheet. The following command works fine for creating a new workbook:

newbook template:=TimeAtAlt.ogw;

But, when I try to add a worksheet, using the following:

newsheet template:=TimeAtAlt.ogw sheet:=Sheet1;

I get an Attention Box that says,"Format error ocurred during reading. File may be damaged."

Is this right? Origin cannot create analysis worksheets using templates, only analysis workbooks?

And if so, how does one add analysis worksheets using an existing template?
2   L A T E S T    R E P L I E S    (Newest First)
Drbobshepherd Posted - 06/27/2012 : 10:38:49 AM
Kathy,

Thank you. Your suggestion to use wcopy worked great.

Actually, I found your second suggestion more efficient ("In case you need to do some data manipulation in between you creating different worksheets(i.e. your sheet1 is not an empty worksheet any more), you could create a new workbook with the analysis template, and copy the worksheet similarly with wcopy.")

Because all my Analysis worksheets were the same, I just

(1) created a workbook with my Analysis template, and then

(2) used wcopy in a loop to create as many Analysis worksheets as I needed.

I found I could even do this after running an analysis because wcopy has a "copydata:=0" option that creates copies without data.

Thanks again,
DrBobShepherd
Kathy_Wang Posted - 06/26/2012 : 02:31:22 AM
Hi,

An analysis template is a workbook(.ogw format), so you could only create new workbook from analysis template.

When you create a new worksheet, the "template" should be .otw format, that's why in your script, there is a format error.

So to add worksheets based on a certain analysis template, you should:
1, Create a new workbook with the analysis template, the workbook contains one worksheet in your case;

2, Add an empty new worksheet to the workbook with the default template "Origin", which for example is Sheet2;

3, Copy the content in Sheet1 into Sheet2 with the wcopy command;
the syntax should be
wcopy iw:=[Book1]Sheet1! ow:=[Book1]Sheet2!


In case you need to do some data manipulation in between you creating different worksheets(i.e. your sheet1 is not an empty worksheet any more), you could create a new workbook with the analysis template, and copy the worksheet similarly with wcopy.

For more information of the x function wcopy, you may refer to:
http://www.originlab.com/www/helponline/Origin/en/Programming/mergedProjects/X-Function/X-Function/Wcopy.html

Hope this information helps!

Kathy
Originlab

The Origin Forum © 2008 Originlab Corporation Go To Top Of Page
Snitz Forums 2000