Saving with filename from excel

2018 5 23
1 个回答
回答已采纳
更新时间：2018 5 23
2 次查看（30 天）

0 个投票

Hi
I getting text from excel cell A1. This value changes for different dataset.
Question: How to use it as a filename for saving image.
I am currently using saveas(gcf,'Test.jpg');
or saveas(gca, fullfile(folderName, 'Test'),'jpeg');
Thanks

7 个评论
显示 5更早的评论 隐藏 5更早的评论

TAB
TAB 2018-5-23
fname = xlsread('your_excel.xlsx', 'A1');
saveas(gcf, [fname '.jpg']);
Siva Ratnasingam
Siva Ratnasingam 2018-5-23
Thank for your reply.
Followed the code. I displayed fname and it shows the correct name but it is showing an error.
Invalid filename: .jpg
Siva Ratnasingam
Siva Ratnasingam 2018-5-23
IT still show an error:
Error using saveas (line 96)
Invalid filename.
My code:
fname= xlsread('c:\data.xlsx','sheet1','a1');
saveas(gcf,fname, 'jpg'); also tried '.jpg'
disp(fname);
disp shows 'testing123'
invalid filename.
I tried
saveas(gcf,'testing123', 'jpg');
it saves as testing123.jpg
Paolo
Paolo 2018-5-23
Try
saveas(gcf,cell2mat(fname),'jpg')
Siva Ratnasingam
Siva Ratnasingam 2018-5-23
It works.
Thank you very much Paolo
Paolo
Paolo 2018-5-23
You are welcome, I wrote an answer for the question so that other people can easily find the solution if they are facing the same problem.

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Paolo
Paolo 2018-5-23

1 个投票

It does not work because the string contained in fname is wrapped inside a cell.
You must convert the cell to the data type contained within it.
Use:
saveas(gcf,cell2mat(fname),'jpg')

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by