| Author |
 Topic  |
|
|
SvenP
29 Posts |
 Posted - 02/18/2010 : 07:53:25 AM
|
Origin Ver. 7.5 and Service Release SR6
Operating System: WinXP
Hello,
I have one question. I loaded an 8 bit colour graphic into Origin and I get a matrix. Now I want to convert this matrix into a worksheet.
Is it possible to convert this matrix into a worksheet, without converting prior to greyscale? It is very important for my next steps on this worksheet.
Thanks. |
|
|
easwar
USA
1964 Posts |
Posted - 02/18/2010 : 09:14:05 AM
|
Hi,
Do you mean you wish to keep the R, G, and B values intact? If that is what you want, you should use the Image->Conversion->RGB Split menu item to first split your image-baed-matrix to separate R, G, B matrices, and then convert them to worksheet.
Can you tell us more about why you are converting to worksheet, and what you do with the worksheet based data?
Thanks,
Easwar
OriginLab
|
 |
|
|
SvenP
29 Posts |
Posted - 02/18/2010 : 12:03:32 PM
|
Thanks for your reply. I will try your suggestion.
I want to get the data out of diagrams to campare it with my data or make calculations on that data. For example I needed the X-ray absorption of copper oxides. So I took a screenshot of a diagram in a paper, cut the diagram in Gimp and load the jpeg into Origin.
I wrote a script in Origin to get the data, means column A=energy and B=intensity.
So everything is fine if the background ist white and the graph black. But today I had a diagram with three graphs in different colours and also with artificial lines.
And now it would be much easier to load a colour image. Then I can tell Origin give me for example the green graph.
Greetings.
|
|
|
|
easwar
USA
1964 Posts |
Posted - 02/18/2010 : 12:10:34 PM
|
Hi,
I apologize, I did not note earlier you have version 7.5
The procedure I outlined is available in version 8.x Pro.
If you just want to digitize points from a graph, and don't mind doing that manually, there is a file exchange tool for that:
http://originlab.com/FileExchange/details.aspx?fid=8
Easwar
OriginLab |
|
|
|
SvenP
29 Posts |
Posted - 02/18/2010 : 1:07:10 PM
|
Yes, that is a really good alternative, especially for bad images. Thanks for that tool.
By the way this reminds me of another thing. I plotted a mass spectrum. Now I want to have the masses and their intensity in a worksheet. What I did? I took the screen reader and wrote the x and y coordinate into a worksheet. With a mass spectrum with for instance 60 masses this procedure takes a lot of time and the work is very stupid.
Is there an easier way? There must be. |
|
|
|
easwar
USA
1964 Posts |
Posted - 02/18/2010 : 1:21:04 PM
|
Hi,
If you mean you want some automated way of scanning the line in the image and creating a dataset, there is no built-in or file-exchange tool for doing that currently.
You may want to look at some other products that allow automatic digitizing such as:
http://www.silkscientific.com/graph/index.htm
http://www.getdata.com.ru/
Easwar
OriginLab
|
|
|
|
SvenP
29 Posts |
Posted - 02/18/2010 : 1:42:10 PM
|
No no the thing with digitizing graphs is ok.
I mean when I click with the screenreader on one peak of a mass spectrum. Then Origin shows the x-y value in this little window. And my question is, is possible that Origin writes this value into a worksheet? |
|
|
|
easwar
USA
1964 Posts |
Posted - 02/18/2010 : 1:47:15 PM
|
Hi,
Ok, I misunderstood your question...
Sure the screen reader (and other tools) can be accessed programmatically to get the information such as coordinates, see the examples here:
http://wiki.originlab.com/~originla/wiki/index.php?title=Script:Getting_Points_from_Graph
This is part of the LabTalk guide for version 8.1. Some of those examples may be compatible with 7.5. You can download the 8.1 demo and try the script.
If on the other hand you just want to find y values for the curve at new/pre-defined x values, you may just want to do interpolation. Version 8.1 has a tool to interpolate an x-y curve at x values specified in another column.
Easwar
OriginLab |
|
|
| |
Topic |
|
Q: Converting matrix to worksheet