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
 copy a worksheet

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
scalpa Posted - 12/10/2020 : 10:39:40 AM
Origin 2021 and Service Release (Select Help-->About Origin):
Operating System:windows 10

Dear all,

Sorry for a probably very naive question: I'd like to develop a project in which I have one set of data (that I can amend over time) that undergoes different transformations and analyses, each of which being in a different folder. so all the analyses would operate on the same set of data (a "master" worksheet). If I correct this master worksheet, all the analyses would also immediatly be modified in their respective folders. "duplicate" doesn't work. How should I proceed ?

Thanks!

Scalpa
4   L A T E S T    R E P L I E S    (Newest First)
scalpa Posted - 12/11/2020 : 03:28:12 AM
I see.
It looks that it's exactly what I'm looking for!
thank you so much !
all best

Scalpa
YimingChen Posted - 12/10/2020 : 2:19:23 PM
Hi Scalpa,

You can use data connector to realize it. First prepare two project files, one just has the master workbook with the data (this project works as a data repository). In the second project, active a worksheet, select menu Data-> Connect to File-> Origin File, where you can choose the workbook to connect to.

This way, you can pulling data from project 1 and run analysis in project 2. Also analysis in project 2 will get updated upon any change of the data in project 1.

Please also check this blog:
http://blog.originlab.com/using-origin-project-as-data-repository-with-the-origin-connector

See if it works.

James
scalpa Posted - 12/10/2020 : 11:01:48 AM
Thanks a lot, it works very well ! Any chance I do the same with the entire workbook ?
Thanks again !

scalpa
YimingChen Posted - 12/10/2020 : 10:51:38 AM
You can highlight the columns or entire worksheet to be duplicated, right click and select Copy Columns to..., this is an operation that can be part of your analysis template.

James

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