| T O P I C R E V I E W |
| johannes91131 |
Posted - 11/06/2013 : 03:14:15 AM
Hi,
i´m a student and trying to compose a script allowing me to import about 200 various excel files, which all contain 2 columns of data, that I would like to be plotted in a simple XY graph. I already got some pieces of the script written, however am still struggling with the import of the files and a suitable loop so that all imported files get plotted the way I want it to.Can you help me please?
I´m using Origin Pro 9G. Would be grateful for any help.
Regards
johannes91131
|
| 3 L A T E S T R E P L I E S (Newest First) |
| greg |
Posted - 11/18/2013 : 3:34:28 PM
Use something like:
plotxy iy:=[Book1]Sheet2!(2,3) plot:=200 ogl:=[<new template:=MyLine>]
|
| johannes91131 |
Posted - 11/07/2013 : 07:28:34 AM
thank you very much.
the script works perfectly fine. now I was asked to add a 3rd column of data to the existing two columns of the excelf files and plot column 2 as x-axis and column 3 as y-axis in a seperate graph window and not together into one. How can I tell the program to use one active worksheet and plot two different graphs from its data into two seperate graph windows. greg could you help me out one more time please?
Regards
johannes91131 |
| greg |
Posted - 11/06/2013 : 10:47:41 AM
Here is some basic code:
dlgfile gr:=Excel mu:=1;
loop(ii,1,fname.GetNumTokens(CRLF))
{
file$ = fname.GetToken(ii,CRLF)$;
// Customize Excel import options as needed
impExcel fname:=file$
lname:=1
desig:=<Unchanged>
options.names.FNameToBk:=0;
plotxy (1,2) plot:=200;
}
|
