Convert a matrix in the workspace into Excel in GUI

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?

Answer 1

[Fangjun Jiang]

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.

[Arif]

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]

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

Answer 2

[Sean de Wolski]

Well I would recommend looking at:

guide

to develop your GUI, and xlswrite to develop your excel export.

[Arif]

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