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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Batch import and plot into same graph
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

jrls996

Australia
2 Posts

Posted - 07/24/2015 :  12:37:48 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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?

Edited by - jrls996 on 07/24/2015 12:39:40 AM

AmandaLu

439 Posts

Posted - 07/24/2015 :  06:08:29 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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

Edited by - AmandaLu on 07/24/2015 06:28:39 AM
Go to Top of Page

jrls996

Australia
2 Posts

Posted - 07/26/2015 :  8:38:46 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you very much, Amanda. This worked perfectly.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000