The Origin Forum

The Origin Forum

All Forums

Origin Forum

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:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
BryanK	Posted - 11/28/2014 : 08:32:33 AM V.9.0 windows 7 Hello, I have written the following simple script for batch import. %A = wks.name$; %B = _treated; wo -s; wks.colsel(13,1); wks.colsel(14,1); wks.export.cntrl = 8; // Just export selected data - no headers wks.export.separator$ = "\t"; save -wh %H %A%B.dat; wo -s; //Remove selections It works fine in the script window and it works as expected for the final file if placed in the "Script at the end" box of Batch Processing. Unfortunately, in the intended "Script after each process" box, files are exported empty (1 kb). Is it something that I have missed or is this a bug? The idea is to export, en-mass, the final two columns of each -new- workbook with the name wks.name$_treated. Thus, ignoring empty books and books that were batch processed earlier. Does anybody have any ideas? Thanks, Bryan
2 L A T E S T R E P L I E S (Newest First)
BryanK	Posted - 12/05/2014 : 06:10:11 AM Wow. Thanks Zheng. That was incredibly easy! I made a quick change to my code which works perfectly in the batch window for each file: fdlog.openpath(P); // choose directory; %A = wks.name$; %B = _treated; wo -s; wks.colsel(13,1); wks.colsel(14,1); expASC type:=1 path:=%P%A%B select:=1 separator:=1 longname:=0 units:=0 comment:=0; wo -s;
lkb0221	Posted - 12/03/2014 : 5:44:08 PM Hi, Please try using expASC X-Function to do the export: http://www.originlab.com/doc/X-Function/ref/expASC Zheng OriginLab

The Origin Forum