Unable to Plot from Excel

3 次查看（过去 30 天）
Avinav Kumar
Avinav Kumar 2020-10-12
评论： Walter Roberson 2020-10-12
I am unable to plot from Excel Sheet. My code is s follows. If someone can please help
function pushbutton1_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton1 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
[file, path] = uigetfile('*.xls');
handles.fileName = fullfile(file, path);
guidata(hObject,handles);
% --- Executes on button press in pushbutton2.
function pushbutton2_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton2 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
if isfield(handles, 'fileName')
filename = get(handles.fileName);
values = xlsread(filename);
xCol = values(:,2);
yCol = values(:,3);
set(handles.axes1,'Visible','on');
plot(handles.axes1,xCol,yCol)
end
  3 个评论
显示 1更早的评论
Avinav Kumar
Avinav Kumar 2020-10-12
I am getting this error:
Error in
matlab.graphics.internal.figfile.FigFile/read>@(hObject,eventdata)understandingthree('pushbutton2_Callback',hObject,eventdata,guidata(hObject))
Error while evaluating UIControl Callback.
Avinav Kumar
Avinav Kumar 2020-10-12
Error using get
Invalid handle
Error in understandingthree>pushbutton2_Callback (line 92)
filename = get(handles.fileName);
Error in gui_mainfcn (line 95)
feval(varargin{:});
Error in understandingthree (line 42)
gui_mainfcn(gui_State, varargin{:});
Error in
matlab.graphics.internal.figfile.FigFile/read>@(hObject,eventdata)understandingthree('pushbutton2_Callback',hObject,eventdata,guidata(hObject))
Error while evaluating UIControl Callback.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2020-10-12
handles.fileName = fullfile(file, path);
That creates fileName as a character vector field inside handles.
filename = get(handles.fileName);
If handles.FileName were a handle, then that would return a structure of public properties of the handle.
However, handles.FileName is not a handle, just a character vector. You just need
filename = handles.fileName;
  2 个评论
Avinav Kumar
Avinav Kumar 2020-10-12
Still i am getting error having changed to filename = handles.fileName;
function pushbutton1_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton1 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
[file, path] = uigetfile('*.xls');
handles.fileName = fullfile(file, path);
guidata(hObject,handles);
% --- Executes on button press in pushbutton2.
function pushbutton2_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton2 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
%filename = get(handles.import,'String');
if isfield(handles, 'fileName')
filename = handles.fileName;
values = xlsread(filename);
xCol = values(:,2);
yCol = values(:,3);
set(handles.axes1,'Visible','on');
plot(handles.axes1,xCol,yCol)
end
Walter Roberson
Walter Roberson 2020-10-12
[file, path] = uigetfile('*.xls');
handles.fileName = fullfile(file, path);
The first output from uigetfile is the file name, and the second output is the directory.
The first input to fullfile should be the directory and the second input is the file name.
You are passing in the file name first and then the directory name, so you are going to be constructing a file name such as h93_b3.xlsx\Users\Aninav\Desktop\MATLAB\project7 when you wanted \Users\Aninav\Desktop\MATLAB\project7\h93_b3.xlsx

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by