| T O P I C R E V I E W |
| Snapshot83 |
Posted - 04/29/2019 : 05:12:47 AM
Hi,
I would like to learn how I can automatize a function (something like "batch processing"). I have an huge file with different folders and for each of them I need to copy/paste some columns in a new sheet. Up to now I have to repeat the operation n-times for each folder, due to the fact that I am not able to do it in some "custom" or automatic way. I either don't know if it is possible to do that as I wish and for this reason I am here asking for your help. Any suggestion ? Thanks in advance.
Origin 2018b b.9.5.5.409 (Academic)
Operating System:Windows 10 |
| 3 L A T E S T R E P L I E S (Newest First) |
| Chris D |
Posted - 05/02/2019 : 08:54:18 AM
Hi Snapshot83,
My interpretation of your question is:
1. You have a big project file with many folders.
2. I assume you have many workbooks in each folder.
3. Each workbook may contain one or more worksheets.
4. For each worksheet in each workbook in each folder (essentially all worksheets in the project), you want to copy some columns to a new worksheet.
Is that correct?
My question(s):
1. Is the new worksheet one single worksheet with all the copied columns from the entire project?
or
2. One new worksheet for each folder?
or
3. One new worksheet for each individual workbook in project?
or
4. One new worksheet for each individual worksheet in project?
The solution would seem to lie in creating an appropriate LabTalk script to automate this.
Thanks,
Chris Drozdowski
Originlab Technical Support
|
| cpyang |
Posted - 05/01/2019 : 4:21:13 PM
quote:
Originally posted by Snapshot83
... I have an huge file with different folders ...
You mean an OPJ file right?
And you would like to be able to select datasets from such an OPJ and do further processing right?
This is basically why we created Origin Connector, which allows one OPJ to connect to data in another OPJ so the data are not duplicated.
CP
|
| YimingChen |
Posted - 04/30/2019 : 09:16:45 AM
Hi,
If you want to select common columns of each sheet to copy over, you may try Append Worksheet tool. Select from menu Worksheet: Append Worksheet.... In the dialog, you can set Range to Specified Columns to only append certain columns of worksheets. Hope this works for you.
Thanks,
James |
