Exe MATLAB file unable to plot Graph

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

[Avinav Kumar]

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.

Answer 1

[Walter Roberson]

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.

[Avinav Kumar]

How will i read reall time data from excel. My data from sensor to excel will keep on changing. Have tried activeX but not successful.

[Walter Roberson]

My understanding is that using ActiveX is your only hope for reading real-time data from Excel. Excel locks the file, so if you are not communicating with Excel you are going to have difficulty reading or writing the data because of the locks.

[Walter Roberson]

My recommendation would be to not use Excel for real-time updates if you can avoid it.

Note that .xlsx files are internally .zip files containing several files that are mostly XML. Each worksheet has its own XML. When new data is added to a worksheet, it may be necessary to rewrite the entire XML file (and re-zip to create the .xlsx file).

The created XML worksheet files are not "journal" files. They are not a list of "transactions", each updating the earlier content, so making an update is not as easy as adding additional text entries to the end of the XML: it is the completed worksheet that is stored.

Excel is not a database. If you need a centralized datastore to mediate transactions between different processes so that you do not have to keep re-inventing communication protocols between real-time processes, then use a database.

[Avinav Kumar]

Can you please suggest which database will be easy to use

[Avinav Kumar]

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