import data using GUIs

Question

Zine 2013-3-24

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/68470-import-data-using-guis

Hello gents, I have some data to process in MATLAB, my data are in xlsx files. I want to create a user interface to process this data by first importing it using the same GUI and then plot the results, my question is how to import data using gui?

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2013-3-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/68470-import-data-using-guis#answer_79759

You might try a listbox arrangement like this: http://www.mathworks.com/matlabcentral/fileexchange/24224. It gives a good GUI framework for starting something like this.

You could fill the listbox with .xlsx files, then when the user clicks on one, it reads it in and plots the results in an axes. You don't have to use image files and display them. You could adapt it to xlsx files and plot them.

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

请先登录，再进行评论。

Answer 2

Mahdi 2013-3-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/68470-import-data-using-guis#answer_79874

I would suggest using the uigetfile function and then using the load function by using a pushbutton.

Using GUIDE, make a pushbutton and go to the callback, then type

% This lets you navigate to the file that you want.

[filename, pathname]=uigetfile

Path=stract(pathname,filename)

YourFile=load(Path)

Basically, your data now has the string YourFile in a matrix from the .xslx file.

7 个评论
显示 5更早的评论隐藏 5更早的评论

Image Analyst 2013-3-26

编辑：Image Analyst 2013-3-26

在 MATLAB Online 中打开

Several problems with Mahdi's code. There is no "stract" function, and struct wouldn't have been right either. He should have put "fullfile" instead. Also the load() is not what you want either. Documentation for load doesn't say anything about it being able to understand Excel format files. You should use xlsread(), which is meant for this:

[num, txt, raw] = xlsread(fullFileName);

I do not recommend using uigetfile unless you want a tedious user interface or do not have a bunch of xls files to process. I'd recommend a listbox (like I showed) if you have a bunch of xls files that the user might want to select from.

Next, and most importantly, you should not use Path as the name of one of your variables, since that is a built-in reserved variable in MATLAB that you definitely don't want to blow away by replacing it with the name of your user's file.

Finally, this does not make sense: "your data now has the string YourFile in a matrix from the .xslx file". Your data does not have the string 'YourFile' in it. Your data is in the workbook and needs to be transferred to a MATLAB variable. If you used xlsread, you'd have one or more cell arrays. None of them would have a string YourFile in them. Two of the arrays (txt and raw) would have cells, where the cell array cells' contents are the contents of the Excel cells. Two cell arrays (num and raw) would have the numbers from the Excel cells in the cell array cells.

Is there some reason why you can't just replace the boilerplate code in the function I gave you with your own code? It does a lot of the heavy lifting for you so you don't have to learn it all from scratch.

Mahdi 2013-3-26

Thanks! I had no idea fileparts even exists or the trailing slash issue. That line definitely helps with writing my codes as well and it makes sense!

Zine 2013-3-26

Thanks very much gents, your discussion was very very helpful for me and I can set my question to solved, even it answers some other questions about the subject that I wanted to ask later, your answers are both accepted and I will tick them if possible

请先登录，再进行评论。