Exe MATLAB file unable to plot Graph

3 次查看（过去 30 天）
Avinav Kumar
Avinav Kumar 2020-10-13
评论： Avinav Kumar 2020-10-18
Hi,
I have created an exe MATLAB file. While the same program runs perfectly in MATLAB compiler, plotting graphs read from excel. In exe file cretaed it is able to read the excel file, but unable to plot the graph. Please Guide
function varargout = understandingfour(varargin)
% UNDERSTANDINGFOUR MATLAB code for understandingfour.fig
% UNDERSTANDINGFOUR, by itself, creates a new UNDERSTANDINGFOUR or raises the existing
% singleton*.
%
% H = UNDERSTANDINGFOUR returns the handle to a new UNDERSTANDINGFOUR or the handle to
% the existing singleton*.
%
% UNDERSTANDINGFOUR('CALLBACK',hObject,eventData,handles,...) calls the local
% function named CALLBACK in UNDERSTANDINGFOUR.M with the given input arguments.
%
% UNDERSTANDINGFOUR('Property','Value',...) creates a new UNDERSTANDINGFOUR or raises the
% existing singleton*. Starting from the left, property value pairs are
% applied to the GUI before understandingfour_OpeningFcn gets called. An
% unrecognized property name or invalid value makes property application
% stop. All inputs are passed to understandingfour_OpeningFcn via varargin.
%
% *See GUI Options on GUIDE's Tools menu. Choose "GUI allows only one
% instance to run (singleton)".
%
% See also: GUIDE, GUIDATA, GUIHANDLES
% Edit the above text to modify the response to help understandingfour
% Last Modified by GUIDE v2.5 13-Oct-2020 08:48:21
% Begin initialization code - DO NOT EDIT
gui_Singleton = 1;
gui_State = struct('gui_Name', mfilename, ...
'gui_Singleton', gui_Singleton, ...
'gui_OpeningFcn', @understandingfour_OpeningFcn, ...
'gui_OutputFcn', @understandingfour_OutputFcn, ...
'gui_LayoutFcn', [] , ...
'gui_Callback', []);
if nargin && ischar(varargin{1})
gui_State.gui_Callback = str2func(varargin{1});
end
if nargout
[varargout{1:nargout}] = gui_mainfcn(gui_State, varargin{:});
else
gui_mainfcn(gui_State, varargin{:});
end
% End initialization code - DO NOT EDIT
% --- Executes just before understandingfour is made visible.
function understandingfour_OpeningFcn(hObject, eventdata, handles, varargin)
% This function has no output args, see OutputFcn.
% hObject handle to figure
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
% varargin command line arguments to understandingfour (see VARARGIN)
% Choose default command line output for understandingfour
handles.output = hObject;
% Update handles structure
guidata(hObject, handles);
% UIWAIT makes understandingfour wait for user response (see UIRESUME)
% uiwait(handles.figure1);
% --- Outputs from this function are returned to the command line.
function varargout = understandingfour_OutputFcn(hObject, eventdata, handles)
% varargout cell array for returning output args (see VARARGOUT);
% hObject handle to figure
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
% Get default command line output from handles structure
varargout{1} = handles.output;
% --- Executes on button press in pushbutton1.
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)
handles.fileName = uigetfile('*.xls');
guidata(hObject, handles);
fileName = handles.fileName;
filename = xlsread(fileName);
x =filename(:,2);
y= filename(:,3);
plot(x,y)
ax=gca;
ax.YAxis.Exponent = 0;
xlabel('Strokelength(in)');
ylabel('load(lbs)');
title('Surface Dynacard');
drawnow
  1 个评论
Avinav Kumar
Avinav Kumar 2020-10-13
Only when i add excel file to the folder created, on running the exe file the graph is plotted. I want to read excel file from any where in the computer.

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson
Walter Roberson 2020-10-13
编辑：Walter Roberson 2020-10-18
we already went through this.
https://www.mathworks.com/matlabcentral/answers/611126-unable-to-plot-from-excel#comment_1053041
You need to use the path and filename returned by uigetfile.
  5 个评论
显示 3更早的评论
Avinav Kumar
Avinav Kumar 2020-10-18
Can you please suggest which database will be easy to use
Avinav Kumar
Avinav Kumar 2020-10-18
exl = actxserver('excel.application');
exlWkbk = exl.Workbooks;
[FileName, FilePath] = uigetfile('*.xls*', 'Open Excel File');
exlFile = exlWkbk.Open(fullfile(FilePath, FileName));
exlSheet1 = exlFile.Sheets.Item('Sheet1');
robj = exlSheet1.Columns.End(4); % Find the end of the column
numrows = robj.row; % And determine what row it is
dat_range = ['B:C' num2str(numrows)]; % Read to the last row
rngObj = exlSheet1.Range(dat_range);
exlData = rngObj.Value;
The above code is throwing an error Error in usingexcelserver (line 9)
rngObj = exlSheet1.Range(dat_range);
Please guide

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by