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
 Origin Forum
 Appending Worksheet: How define a selection ?

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
Snapshot83 Posted - 11/13/2017 : 11:48:42 AM
Does anybody know if it is possible create a default operation in order to select multiple colomuns using the "Appending worksheet" function ?
I have different sheets containing 5 coloumns, but I wanna keep, from all of them, just the 4th and 5th coloumn (i.e. D and E). I would like choice such coloumns by menu, but I am unable to do that, since I can select or only D or only E coluomn, but not both.
The only way I can do this it seems just selecting "Custom columns" and then, select manually all the columns which I need (in this case D and E). There is a shortcut I can use ? It might be so useful, since I have to use this functions many times for my data anaysis. I hope I explained it clearly (but I am not sure). Anyway, thanks in advance.


Origin 2017 64b
4   L A T E S T    R E P L I E S    (Newest First)
YimingChen Posted - 11/17/2017 : 09:25:37 AM
Hi,

In the Append Worksheet dialog, there's an option "Common columns" other than "Custom columns" for selecting specified columns, which allows you select common columns in each worksheet. Have you tried that? Hope that helps.

Yiming
Snapshot83 Posted - 11/16/2017 : 05:29:45 AM
Any other suggestions ?
Snapshot83 Posted - 11/14/2017 : 03:53:20 AM
Hi, I try to explain better my issue.

I have a serie of folders, each of these contains 10 worksheets. I need to copy columns D and E of all of these sheets in a new worksheet. So, I kindly ask the easiest way to do that.

Thanks for Your help.
arstern Posted - 11/13/2017 : 4:16:08 PM
Hi,

Have you tried using Batch Processing? You can use this feature if you plan on consistently append column D and E. Also you mentioned using append worksheet? From reading your description of what you want to do it seems that Copy Column would work better? Either way you can use Batch Processing with Copy Column or Append Worksheet.

Tutorials on Batch Processing:
https://www.originlab.com/doc/Tutorials/Batch-Processing

Example:
1. Highlight column D and E
2. Select Worksheet -> Copy Columns to -> Open Dialog
Book.



3. Make sure to set Recalculate to Auto. For Destination Columns select New Sheet. Select Ok. A new sheet (Sheet 2) should be created where colmn D and E are copied.



4. With the workbook activated, Select File -> Select Save Workbook As Analysis Template. Save your analysis template.



5. Now you are ready for batch processing.
a. Select The Batch Processing Icon shown by the Arrow. With the Batch Processing dialog box open, you have a couple ways to customize.
b. In this example I load the analysis template that I saved from the previous step.
c. I select the file I want to import and apply the analysis to within File List.
d. Under Delete Intermediate Workbook if you have this selected then only the result sheet (Column D and E) will be opened in the project. If you have it unselected then the original data and the new analysis sheet with copied column D and E will open together in the project.




Hope this helps,
Aviel
OriginLab

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