I do have calculator GUI, how do i export each answer to excel? which will keep every answer in calculator to the excel?

1 次查看（过去 30 天）

john john 2011-12-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/24707-i-do-have-calculator-gui-how-do-i-export-each-answer-to-excel-which-will-keep-every-answer-in-calc

I do have calculator GUI, how do i export each answer to excel? which will keep every answer in calculator to the excel? because the one i had every answer will just replace the data not keep on adding... any help?

Code sample : a = get(handles.input1_gamma,'String'); %gamma b = get(handles.input2_h,'String'); %h c = get(handles.input3_q,'String'); %q d = get(handles.input4_power,'String'); %POWER % a and b are variables of Strings type, and need to be converted % to variables of Number type before they can be added together

    out = [str2num(a) * str2num(b)* str2num(c)];
    a = get(handles.input1_gamma,'String'); %gamma
    b = get(handles.input2_h,'String'); %h
    c = get(handles.input3_q,'String'); %q
    d = get(handles.input4_power,'String'); %POWER
    out = [str2num(a) * str2num(b)* str2num(c)];
    e = {'Power','gamma','H','Q'; out, str2num(a),str2num(b),str2num(c)};
    xlswrite('answers.xls', e,'Sheet1');