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
 Automation of Data Processing and Plotting
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

hwo1

GERMANY
Posts

Posted - 10/20/2004 :  11:37:56 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): OriginPro 7.5
Operating System: Windows XP Pro

I have a couple (>150) of datasets that should be all treated in the same way:

importing the data into origin
set one column as "Z"
convert it to a matrix
plot a graph

Does Origin provide any simple (!) approach to record this as a makro or is there any other way to perform these steps in a routine?

Thanks a lot for your attention.

Mike Buess

USA
3037 Posts

Posted - 10/20/2004 :  12:03:45 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You might look at this... http://www.originlab.com/fileexchange/details.aspx?fid=86

Mike Buess
Origin WebRing Member
Go to Top of Page

hwo1

GERMANY
Posts

Posted - 10/28/2004 :  11:14:40 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Mike,

I have already tried the tool . Unfortunately it seems only to work if the graph is directly generated from the imported and formated worksheet. But if the graph is generated from a follow on worksheet as in this case from the matrix it seems not to work.

I have tried the tool with only one worksheet and than generated directly a graph and it worked perfect. But anyway I have to transform my data into the matrix.
Go to Top of Page

easwar

USA
1965 Posts

Posted - 10/28/2004 :  11:21:13 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi hwo1,

The tool on file exchange uses the Import Wizard filter mechanism to import the data from each file into a particular worksheet. Note that in the import wizard, when making a filter, one could add script code to the filter, and then the script code will get executed at the end of each import. So in your case, you could add script code that does the matrix conversion, taking the imported data, and then converting it to a matrix, where an existing matrix is updated with the new data. Then, any graph that is based on the existing matrix should also update.

To add script code, go to the (last) Filters Page of the wizard, and check the "Specify Advanced Filter Options" checkbox, which will then open another page where you can place script in an edit box. Note that the script could call an OGS file section if necessary, and could thus also call pre-compiled OC functions for post processing of the imported data.

Easwar
OriginLab

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