write data from gui in excel

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!

Answer 1

[Fangjun Jiang]

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.

[Andrea Gil]

Thank you very much!

Answer 2

[Chirag Gupta]

xlswrite will work from a GUI.

xlswrite(filename,handles.data)

Answer 3

[Fangjun Jiang]

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.

Answer 4

[Andrea Gil]

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!

Answer 5

[Jack Griffin]

pingas