Define filname for exported data with GUI

2015 12 21
1 个回答
回答已采纳
更新时间：2015 12 22
13 次查看（30 天）

0 个投票

Hi guys,
I would like to define the name of an exported xls file via GUI, so I added the following commands to a "filename_callback":
contents=cellstr(get(hObject,'String'));
filename=[contents{get(hObject,'String')}];
assignin('base','filename',contents);
in the next step I use the following command to save my Matrix "results":
save('results','filename','xls');
The Excel-file should have the name, that I add in GUI, but I'm always receiving the error: Error using save Variable 'filename' not found.
Does anybody have an advice?

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

 采纳的回答

Ingrid
Ingrid 2015-12-21

0 个投票

the save command saves the data in .mat format by default. It is not possible to write to xls format with this command, only to ascii if specified by the options. What you are probably looking for is xlswrite
xlswrite(filename,results)

2 个评论
显示 无 隐藏 无

Benno Boehm
Benno Boehm 2015-12-22
Thanks Ingrid, xlswrite(filename,results) works! Is there a command with which I can define "filename" via GUI. I gues my commands:
contents=cellstr(get(hObject,'String'));
filename=[contents{get(hObject,'String')}];
assignin('base','filename',contents);
are not working, because I can not define the variable "filename" with a word!
Ingrid
Ingrid 2015-12-22
why not just use
filename = get(hObject,'String');
before calling
xlswrite(filename,results)
I do not see why you want to assign the variable to your base workspace as this is not necessary

请先登录，再进行评论。

更多回答（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