フィルターのクリア

Info

この質問は閉じられています。 編集または回答するには再度開いてください。

I have a data that can be varied by the user using edit box . How can I output it on excel

1 回表示 (過去 30 日間)
KRUNAL
KRUNAL 2014 年 7 月 10 日
閉鎖済み: MATLAB Answer Bot 2021 年 8 月 20 日
I have created a panel consisting of 3 script box and corresponding 3 edit box in GUI, . I am also using 2 push buttons Save and Cancel.Now, when I run the code and when I type any value in edit box and click save button,it should save it in Excel sheet cell by cell i.e 1st edit box's value should be stored in 1st cell(say A1),2nd in 2nd cell(A2) and so on.
Please help me.
  2 件のコメント
Sara
Sara 2014 年 7 月 10 日
Have you looked at
help xlswrite
KRUNAL
KRUNAL 2014 年 7 月 17 日
I found it through some other method.Thanks for the suggestion.

回答 (1 件)

Image Analyst
Image Analyst 2014 年 7 月 17 日
% Get the strings in the edit boxes.
mystring1 = get(handles.editBox1, 'String');
mystring2 = get(handles.editBox2, 'String');
mystring3 = get(handles.editBox3, 'String');
% Stick it in a cell array
ca = cell(1,3);
ca(1,1) = {mystring1};
ca(1,2) = {mystring2};
ca(1,3) = {mystring3};
% Write to Excel
xlswrite(filename, ca);

この質問は閉じられています。

Community Treasure Hunt

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

Start Hunting!

Translated by