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
 Merging 300+ worksheets in one

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
koskis Posted - 07/02/2018 : 1:39:07 PM
I have imported 300+ .txt files (each of which contain around 12000 data) with partial import through multiple ASCII function, however i need them all to be in one worksheet in order to make a histogram . i use origin8 and i know there is a function Append Worksheets, but i don't seem to find it under Worksheet toolbar in this version of origin. i don't want to sit and spend 3 days manually merging the tables. please help.
1   L A T E S T    R E P L I E S    (Newest First)
arstern Posted - 07/02/2018 : 3:51:55 PM
Hi Koskis,

You will need a minimum version of Origin 2015 which is Origin 9.0 to be able to use the Append Worksheet function.

See documentation:
https://www.originlab.com/doc/X-Function/ref/wAppend

You could maybe try to import the data into one worksheet. If you are using Import Mulitple ASCII -> For Multi-File Import Mode tab -> Select Start New Column.

Similarly, if you already have data in a worksheet and want to import a new dataset into the same worksheet. Activate the worksheet -> Select Import Single ASCII -> and Under 1st File Import Mode -> Select Start New Columns.

Aviel
OriginLab
Technical Support

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