The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Export script for many files
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

neutrondude

Brunei
Posts

Posted - 08/25/2009 :  10:19:06 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. 7.5 and Service Release (Select Help-->About Origin):
Operating System: XP prof.

I have been wondering for a long time whether it is possible to export (not import) many files- let say all the worksheets in a project in one go. I have many- hundreds and would like to export them after having manipulated them in Origin. Are there any script that can do that?

thanks a lot in advance

greg

USA
1378 Posts

Posted - 08/31/2009 :  1:15:30 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Here is a script for 7.5 and earlier:

// Setup the WKS.EXPORT object
wks.export.c1 = 1;
wks.export.c2 = 0; // All columns
wks.export.r1 = 1;
wks.export.r2 = 0; // All rows
wks.export.separator$ = "\t"; // Use TAB separator
wks.export.cntrl = 7; // Export Column Names + Data + Column Labels
// Loop over al worksheets in the project
doc -e W {
save -wh %H D:\TEMP\%H.DAT; // -wh uses WKS.EXPORT object
}
Go to Top of Page

neutrondude

Brunei
Posts

Posted - 04/07/2010 :  11:18:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear Origin,

I am trying to export a lot of data simulatenously (all worksheets to ascii files)
I have tried the above mentioned script but it does not work. What I do is to execute the following commands in the script window:

// Setup the WKS.EXPORT object
wks.export.c1 = 1;
wks.export.c2 = 0; // All columns
wks.export.r1 = 1;
wks.export.r2 = 0; // All rows
wks.export.separator$ = "\t"; // Use TAB separator
wks.export.cntrl = 7; // Export Column Names + Data + Column Labels
// Loop over al worksheets in the project
doc -e W {
save -wh %H D:\TEMP\%H.DAT; // -wh uses WKS.EXPORT object
}

How do I implement it in Origin 7/7.5?
Could I export certain coumns lets call them Q, Icorr and dIcorr ?

Thanks a lot in advance!

Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000