write data from gui in excel

2 次查看（过去 30 天）
Andrea Gil
Andrea Gil 2011-7-26
回答： Jack Griffin 2015-5-27
Hi! Does anybody know how can a variable calculated on matlab GUI and stored in the handles be written on an already existing excel file?`
Or in other words, does the function xlswrite work at GUI? and if not, which function should be used instead?
Thanks a lot!

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-7-27
The format for range is 'a2:c4' as an example. For a single cell, you need to specify it as 'd4:d4' for example.
The range for 4th column and i+1 row would be
[dec2base27(4),num2str(i+1),':'dec2base27(4),num2str(i+1)]
The function dec2base27() is to convert 1 to 'A', 4 to 'D', 28 to 'AB' etc. It is to facilitate the xlswrite() function. You probably don't have it. I took it from xlswrite.m. Open xlswrite.m and you can find the dec2base27() function. Make it separate so you can use it anywhere else.

更多回答（4 个）

Chirag Gupta
Chirag Gupta 2011-7-26
xlswrite will work from a GUI.
xlswrite(filename,handles.data)
Fangjun Jiang
Fangjun Jiang 2011-7-26
Yes, xlswrite() works anywhere. You need to pay attention in the code where you have the xlswrite() line that you have access to the data, and it's better to specify the full path of the Excel file.
Andrea Gil
Andrea Gil 2011-7-27
But to write only a value on a cell i+1 (i is an input from the user), how would it work?
xlswrite(filename, M, 'range'), M=the matrix 1x1, and which is the range if it is the forth column for the i+1 row? should it be Di+1:Di+1? I am not pretty sure if matlab accepts that, any idea?
Thanks!
Jack Griffin
Jack Griffin 2015-5-27
pingas

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by