Save matrix as a spreadsheet image
显示 更早的评论
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!
采纳的回答
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 个评论
Varun Kumar
2022-7-13
The table generation is fine, but when I open the image up, it is blank. What can I do to fix this? Thanks!
Adam Danz
2022-7-13
Are you using uifigure() and not regular figure()?
Are you supplying the figure handles to uitable (uitable(fig,...))?
Are you using exportapp rather than exportgraphics?
I see you're using R2020b (thanks for filling out the release info). I just tested it in 2020b and it exports the table as a png as expected.
Varun Kumar
2022-7-13
Adam Danz
2022-7-13
I see what's happening and was able to reproduce the problem.
The figure and uitable need to be rendered before exporting the image. If you run the entire code at once, exportapp is called too quickly before the uitable is rendered.
I'll update my answer to include the following two lines that will prevent this problem.
Place these lines before exportapp
drawnow
pause(.5)
drawnow alone did not solve the problem, the additional pause is necessary but the duration of the pause might be reducible.
Varun Kumar
2022-7-13
Varun Kumar
2022-7-13
Adam Danz
2022-7-13
What is your matrix size?
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
