How do I get data to a GUI from excel file

Question

karan 2011-11-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21505-how-do-i-get-data-to-a-gui-from-excel-file

i have tried doing this but have got repeated errors... so i added a pushbutton to open the browse dialog box so that i can select the file i want to extract the data from

function pushbutton4_Callback(hObject, eventdata, handles)
    handles.pushbutton4_Callback = uigetfile;
  guidata(hObject, handles);

and then use the file name to use in a xlsread shown below which is triggered by another push button *

*[num2] = xlsread(handles.pushbutton4_Callback);

For some reason this is not working ....any help any tips on adding multiple files for analysis

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

请先登录，再进行评论。

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

Answer 1

Fangjun Jiang 2011-11-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21505-how-do-i-get-data-to-a-gui-from-excel-file#answer_28308

在 MATLAB Online 中打开

Using the "handles.pushbutton4_Callback" for your Excel file name is really confusing. Also, it's better to specify the full path and name of the file.

[FileName,PathName]=uigetfile;
handles.ExcelFile=fullfile(PathName,FileName);

Then in other function, use

xlsread(handles.ExcelFile);

4 个评论
显示 2更早的评论隐藏 2更早的评论

Fangjun Jiang 2011-11-17

This sounds like developing an application rather than a particular question. It can be done but will certainly require you to add more elements to your GUI and do some coding. There are quite some examples in this link or your local document. http://www.mathworks.com/help/techdoc/creating_guis/f6-6010.html

Also, you can watch Doug's video on this tipic. http://blogs.mathworks.com/videos/category/gui-or-guide/

Post your particular question as you go along.

karan 2011-11-18

I never knew about these videos...seems like they are going to be handy .although i am not quite clear when u said it can be done except it requires ``more elements`` to the GUI ...any hints and tips which might make it easier to follow.

yes this is for a small application....just as a stepping stone

请先登录，再进行评论。