| T O P I C R E V I E W |
| mrandersb |
Posted - 01/26/2011 : 01:57:24 AM
Right now I have a project file where I am "importing" data from other sheets in the project (in the set column value). Because my project is getting rather large, I would like to make a lot of different project files, and then import all important processed data into one project file.
How can I do this simple? And this a very slow process?
Anders |
| 9 L A T E S T R E P L I E S (Newest First) |
| Sam Fang |
Posted - 01/30/2011 : 02:08:10 AM
If you didn't change columns or use columns to evaluate other columns or cells in Set Column Values dialog, then Recalculate will also be forced to None. Obviuosly your above script was in that case.
Sam
OriginLab Technical Services |
| mrandersb |
Posted - 01/28/2011 : 03:39:36 AM
by the way. The recalculate is set back to none even if i only have
type -mb 1;
doc -a C:\Users\f040427\PhD\Origin Test\Append project test\append.opj;
type -me;
in the before formula script |
| mrandersb |
Posted - 01/28/2011 : 03:34:26 AM
thanks, think thats all i needed |
| Sam Fang |
Posted - 01/28/2011 : 02:03:14 AM
For the introduction of doc -a, see Help: Programming: LabTalk
Language Reference> Command Reference> Alphabetical Listing of Commands> Document
You can use folpromt:=0 pgpromt:=0 in pe_rmdir command to cancel the prompt. For more, see Help: X-Functions
Utilities> System > pe_rmdir
Recalculate mode is changed from Manual to None, maybe because range of data in the folder created by doc -a is used in "before formula scripts", but you also call pe_rmdir to delete the folder. Then the range won't exist, which will force Recalculate to None. You can copy the data if you want to set Manual.
Sam
OriginLab Technical Services |
| mrandersb |
Posted - 01/27/2011 : 06:04:10 AM
Seems like I figured it out, but would still like to see the documentation for the two commands.
Also when for example using the command to delete, it promts with a box asking if i'm sure. I would like that it didn't do that, because I want to do it a lot of times and automatically.
When i puc the doc -a command in the "before formula scripts" and set recalculate to manual, it seems like it is set back to none, can I do something so it is kept at manual? |
| mrandersb |
Posted - 01/27/2011 : 05:46:59 AM
Ok I will look into that. I can't seem to find the documentation on the doc -a command, could you give me a link? |
| Sam Fang |
Posted - 01/26/2011 : 10:22:34 PM
You can use doc -a to append the project that you want to import to your current project, it will create a new project folder for this. After you copy your important processed data from it using script, you can use pe_rmdir to delete the new project folder. But it may leave some redundant info in the project.
Sam
OriginLab Technical Services |
| mrandersb |
Posted - 01/26/2011 : 09:58:27 AM
Are there any other techniques i can use ? |
| Sam Fang |
Posted - 01/26/2011 : 04:45:11 AM
It seems that Origin can't import specified data from other project files using LabTalk script currently.
Sam
OriginLab Technical Services |
