Trying to Import Excel Data using GUIDE push button

13 次查看（过去 30 天）
Tessa Aus
Tessa Aus 2016-6-3
评论： Tessa Aus 2016-6-14
I am trying to create a GUI that contains a Push Button that finds an excel file, and then extracts the data and creates a .m file of the Data so that in the future rows can be selected and analyzed using the GUIDE GUI. I am able to find the file with the Push Button but once the file is selected and Open is pressed a series of errors come up.
Here is what I have ...
function pushbutton1_Callback(hObject, eventdata, handles)
path = 'c:\users\userName\my documents\matlab';
filter = '*.csv';
selectedFile = uigetfile(fullfile(path , filter));
num = xlsread(filename);
  3 个评论
显示 1更早的评论
Tessa Aus
Tessa Aus 2016-6-7
编辑：Tessa Aus 2016-6-7
So I was able to manually find the file with the push button and then export it but now I need to find a way to instead find the file then take that file and import it into a .mat file. For example below is noted the InputInspectionFile.xlsx is manually entered and converted instead I want to grab the filename.xlsx that the user chose through file selection. Thanks guys!
% code
FilePath_Callback(hObject, eventdata, handles)
[filename pathname] = uigetfile({'.xlsx'},'File Selector');
fullpathname = strcat(pathname, filename);
text = fileread(fullpathname);
set(handles.FullPathName, 'String', fullpathname);
[num,txt,raw] = xlsread('InputInspectionFile.xlsx');
save('InputInspectionFile')
% code
end

请先登录，再进行评论。

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

采纳的回答

Geoff Hayes
Geoff Hayes 2016-6-8
Tessa - use fullfile rather than strcat to create the full file name from the path and name. If you want to save the data from the Excel file to a mat file, then why not just do
save('myData.mat','raw');
which will save the data extracted from your Excel file into a mat file named myData.mat.
  16 个评论
显示 14更早的评论
Geoff Hayes
Geoff Hayes 2016-6-10
I can't help but wonder why the path to the file is not being prepended to the excelFullfilename. What is the pathname in
[filename pathname] = uigetfile({'.xlsx'},'File Selector');
Tessa Aus
Tessa Aus 2016-6-14
There was something indeed wrong with the file but was not recognizable unless the file was opened not from Matlab. Your code worked, thank you so so much!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by