Save matrix as a spreadsheet image
1 view (last 30 days)
Show older comments
I am trying to programatically save a matrix as a .jpg or .png file. The output should be a jpg that looks like a spreadsheet, similar to an excel document. For example, if the matrix was:
1 2 3
4 5 6
7 8 9
The output of the program should look something like this (screenshot from excel) in a jpg or png file:
What function should I use to make this happen?
Thank you!
0 Comments
Accepted Answer
Adam Danz
on 13 Jul 2022
Edited: Adam Danz
on 13 Jul 2022
Storing numeric data in images makes it difficult to work with those data later on but I remember a use-case for this back when I wanted to quickly snap-shot small data sets for visual reference (still not sure it was the best approach).
Nevertheless, if your matrix fits on a single page, you could put the data in a uitable and then extract the figure using exportapp. Note that precision may be lost since there is a finite number of decimal places that will appear on the table. See uitable documentation to learn how to apply column and row labels.
x = rand(10,5)*100;
fig = uifigure(); % must be uifigure
uit = uitable(fig,'Units','Normalize','Position',[0 0 1 1],'Data', x)
After the figure and uitable are rendered, you can export the figure as an image using exportapp.
% drawnow % only needed if calling exportapp immediately after uitable.
% pause(.5) % only needed if calling exportapp immediately after uitable.
exportapp(fig, 'mytable.png')
7 Comments
More Answers (0)
See Also
Categories
Find more on Specifying Target for Graphics Output in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!