Unable to Plot from Excel
2 次查看(过去 30 天)
显示 更早的评论
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
采纳的回答
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 个评论
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 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!