Info
이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.
I have a data that can be varied by the user using edit box . How can I output it on excel
조회 수: 2 (최근 30일)
이전 댓글 표시
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.
답변 (1개)
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);
댓글 수: 0
이 질문은 마감되었습니다.
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!