Convert a matrix in the workspace into Excel in GUI

1 次查看（过去 30 天）
Arif
Arif 2011-10-19
I have a matrix A of size(n*m) in the workspace. I would like to develop a GUI which has a push button. So whenever I click on it, the matrix A which is present in the workspace convert it into Excel file. So that I can save it easily as Excel file.
Could you please suggest me the code for this?

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-10-19
You just need to run xlswrite. For example,
xlswrite('test.xls',rand(3,4))
Inside your push button callback, you might need to run this:
xlswrite('test.xls',evalin('base','MatrixA')) where 'MatrixA' is your variable name.
  2 个评论
Arif
Arif 2011-10-19
Thanks for your reply.But I want to select my Matrix A from work space whenever I use push button.
Problem is I would like to write a code so whenever I click the push button present on the GUI so first it allows me to choose the required matrix then I have a piece of code which manipulate matrix according to my wish and then save it in excel.
So I would like to choose the matrix in run time process.
Thanks
-Arif
Fangjun Jiang
Fangjun Jiang 2011-10-19
That can be done too. The function who() or whos() can give you a list of variables and their properties. Once you have that list, you can put the list in a ListBox or Popup Menu. Then you can let the user to select the variable name. Once you get the variable name, then the above xlswrite() line can get the job done. Start from here to see some GUI examples.
http://www.mathworks.com/help/techdoc/creating_guis/exampleindex.html

请先登录，再进行评论。

更多回答（1 个）

Sean de Wolski
Sean de Wolski 2011-10-19
Well I would recommend looking at:
guide
to develop your GUI, and xlswrite to develop your excel export.
  1 个评论
Arif
Arif 2011-10-19
Thanks for your reply.Actually I would like to select the required matrix A and there are other matrix also.And whenever I use xlswrite I need to write Matrix name again and again.
Problem is I would like to write a code so whenever I click the push button present on the GUI so first it allows me to choose the required matrix then I have a piece of code which manipulate matrix according to my wish and then save it in excel.
So I would like to choose the matrix in run time process.
Thanks
Arif

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by