Unable to Plot from Excel
显示 更早的评论
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 个评论
Sudhakar Shinde
2020-10-12
Any error you observed?
for more detailed data read excel by below syntax:
[num,text,raw] = xlsread(filename);
Avinav Kumar
2020-10-12
Avinav Kumar
2020-10-12
采纳的回答
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
2020-10-12
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
