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
 Batch import and plot into same graph

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
jrls996 Posted - 07/24/2015 : 12:37:48 AM
Origin Ver.: 2015 Rs2; Operating System: Windows 7 SP1

Hello,

I would like to import data from several EXCEL files into different workbooks and plot several curves (of specific columns on each workbook) into the same graph. Example:
Workbook1 has 3 columns, A, B, C
Workbook2 has 3 column, A, B, C
I want to plot Graph1 with A,B from Workbook1 and A,B from Workbook2. Then Graph2 with A,C from Workbook1 and A,C from Workbook2.

Is is possible to create an analysis template that imports the files and automatically plots them like this?
2   L A T E S T    R E P L I E S    (Newest First)
jrls996 Posted - 07/26/2015 : 8:38:46 PM
Thank you very much, Amanda. This worked perfectly.
AmandaLu Posted - 07/24/2015 : 06:08:29 AM
Hi jrls996,

For your case it is not easy to use analysis template in the current version. Please try the following way:

1. Create a new project. Import all your excel file using File: Import: Excel. Make sure select Import Mode = "Start New Book" for both the first and the rest of excel files.

2. Run the following scripts to create the graphs.

repeat 2 {win -t P;} //create new empty graph
doc -e W //loop all workbooks in the OPJ
{
plotxy iy:=(1,2) ogl:=[Graph1]1!; //create graph
plotxy iy:=(1,3) ogl:=[Graph2]1!;
}

In the coming version, V2016, ImpExcel will have option to enter After Import Scripts, which will make the routine simpler.

Thanks,
Amanda
OriginLab Technical Service

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