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
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Range Notation in Import Script

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 HyperlinkUpload FileInsert 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 - 03/27/2012 : 6:28:05 PM
I'm having a problem with a LabTalk script that works when I use it in a Command window, but doesn't work when I try to use it in an import filter. It seems that the range assignments in the import filter script don't work. Is that normal?

DrBobShepherd

Origin Ver. and Service Release (Select Help-->About Origin): Origin Pro 8.6.0
Operating System: Windows XP
3   L A T E S T    R E P L I E S    (Newest First)
greg Posted - 03/30/2012 : 3:42:29 PM
One thing to watch out for is that your ranges should be generic as possible since import settings may change the Workbook name and/or the Column names. (You can of course set your filter to NOT change those names.)

So rather than explicit name references:
range ra = [Book1]Sheet2!col(C)
use the more generic
range ra = [%H]2!3

Since the %H implies the active Workbook, it can be ommited:
range ra = 1!1
Drbobshepherd Posted - 03/28/2012 : 10:22:37 AM
I just wanted to know if I would be wasting my time debugging my code trying to make the range statements work. I'll give it a try before bothering you with my file.

DrBobShepherd
Sam Fang Posted - 03/28/2012 : 02:55:22 AM
It should work in the import filter. You can send us your script. To send us a file, click Send File to Tech button on the top right of the forum.

Sam
OriginLab Technical Services

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