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 for Programming
 Forum for Origin C
 How to merger multiple worksheets

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
newuser_ca Posted - 08/02/2012 : 4:14:20 PM
OriginPro 8.6 in win7

Hi,

I have several worksheets with index and values. I want to combine them into one worksheet. Here is an example:





Combine the two into ==>



the cell with red is a missing point. it is filled with the previous value.

I wrote loops in Origin C to get one big worksheet. It takes long time to combine them when I have many points in the column.

Is there an easier way to do this in Origin C?

Thanks.
2   L A T E S T    R E P L I E S    (Newest First)
newuser_ca Posted - 08/03/2012 : 09:23:45 AM
that is what I do right now.
Thanks a lot.
Penn Posted - 08/02/2012 : 11:53:04 PM
Hi,

I am afraid there is no way to do this special case directly. Maybe you can try to get the data from worksheet into vector first, and then put back to the merged worksheet after handling by vector.

Penn

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