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
 Worksheet script problem		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Duff

Argentina
42 Posts
Posted - 06/03/2014 :  8:19:47 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 9.1 sr2 64 bits
Operating System: windows 7 64

I have the following worksheet script:
wtranspose iw:=[Book1]Import type:=comment ow:=[Book1]Transpose!;
colcopy -r 1 irng:=[Book1]Transpose!1:30 orng:=[Book1]DATOS!1:30 format:=0 hidden:=0 lname:=0 units:=0 comments:=0 para:=0 usrdef:=0;

and works well.
If the checkbox "Run after import" is selected the the import (many ascii files) becomes too slow.
How do the "auto scripting" when import?
Thanks

Shirley_GZ

China
Posts
Posted - 06/03/2014 :  10:59:36 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Duff,

Origin 9.1 supports transpose data while importing, which is availble in the Import ASCII tool (from menu File: Import: Multiple ASCII )


Please try it, any pronlem, please send us an email tech@originlab.com or reply this post directly.

Originlab Technical Service Team
Edited by - Shirley_GZ on 06/03/2014 11:18:39 PM
Go to Top of Page

snowli

USA
1386 Posts
Posted - 06/04/2014 :  10:18:03 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Origin's Import wizard supports running script after import.

You can watch this video.
http://originlab.com/Index.aspx?go=Support/VideoTutorials&pid=1163

This is old video. So in new version, you can even specify Script to run after each import, or script to run after all data files are imported.

If you later want to save workbook template, then when saving filter on the last page of import wizard, make sure to check Save Filter "In the Window" checkbox. All import settings settings and script will be saved in the workbook.

Thanks, Snow
OriginLab Corp.
Go to Top of Page

Duff

Argentina
42 Posts
Posted - 06/04/2014 :  10:29:51 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
The problem was when "run the script after each import" and solved running after all data files are imported.
Thank you!
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