| Author |
 Topic  |
|
|
praveen248
India
10 Posts |
 Posted - 05/19/2017 : 05:36:32 AM
|
Version 2015,
Hi,
I have to loop through all the folders--> worksheet in the project and I have to copy the data in a single worksheet in a different folder from the data taken from all the worksheets in different folder, How can i Do it?
refer to the picture
B.V.Praveen |
|
|
arstern
USA
237 Posts |
Posted - 05/19/2017 : 10:19:39 AM
|
Hi,
One method that you can use is Append Worksheet. You can do this via the GUI http://www.originlab.com/doc/Origin-Help/append-worksheet or command window http://www.originlab.com/doc/X-Function/ref/wAppend.
For example, select worksheet at the top of the menu --> Select Append Worksheet.
With the append worksheet: wAppend dialog box open. Select the triangle in worksheets to select which worksheets you want to copy into one worksheet. You may want to select sheets in Project to view all sheets.
If you want to use the command window, here is the basic format:
wAppend irng:=([Book1]Sheet1!, [Book1]Sheet2!, [Book2]Sheet1!) method:=row ow:=[<new>]<new>;
See link above for more information.
--Aviel
OriginLab |
 |
|
|
redman
UK
59 Posts |
Posted - 02/16/2018 : 06:44:26 AM
|
| Maybe it is time to expand the "doc -e" to loop among folders. For example, to import data files in different folders to a project with the same folder structure and file names. To loop among folders and sub-folders in the project to find any workbooks, plot all worksheets in the same workbook and save the new graph in the same folder with the same long name as the workbook. |
|
|
| |
Topic |
|
|
|
How to loop through Different Folders in a project