Saving with filename from excel

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 Comments

fname = xlsread('your_excel.xlsx', 'A1');
saveas(gcf, [fname '.jpg']);
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
Try
saveas(gcf,fname,'jpg')
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
Try
saveas(gcf,cell2mat(fname),'jpg')
It works.
Thank you very much Paolo
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.

Sign in to comment.

 Accepted Answer

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')

More Answers (0)

Categories

Tags

Asked:

on 23 May 2018

Commented:

on 23 May 2018

Community Treasure Hunt

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

Start Hunting!