| Author |
 Topic  |
|
|
Snapshot83
United Kingdom
18 Posts |
 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 |
Edited by - Snapshot83 on 04/29/2019 05:59:03 AM |
|
|
YimingChen
1609 Posts |
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 |
 |
|
|
cpyang
USA
1406 Posts |
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
|
|
|
|
Chris D
428 Posts |
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
|
|
|
| |
Topic |
|
How to automatize a function (Copy/paste columns)