write data from gui in excel

Question

Andrea Gil 2011-7-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/12432-write-data-from-gui-in-excel

回答： 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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Fangjun Jiang 2011-7-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/12432-write-data-from-gui-in-excel#answer_17144

在 MATLAB Online 中打开

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.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Andrea Gil 2011-7-28

Thank you very much!

请先登录，再进行评论。

Answer 2

Chirag Gupta 2011-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/12432-write-data-from-gui-in-excel#answer_17004

在 MATLAB Online 中打开

xlswrite will work from a GUI.

xlswrite(filename,handles.data)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Fangjun Jiang 2011-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/12432-write-data-from-gui-in-excel#answer_17005

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 4

Andrea Gil 2011-7-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/12432-write-data-from-gui-in-excel#answer_17095

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!