How to read excel data in matlab app designer and use it for further calculation eg. plot data?

hello,

I want to read to excel file and want to excess the data for further calculation. the program is written below, here i have used pushbutton and drop down for reading data. Based on option it will read the excel data:

% Button button pushed function

function ButtonButtonPushed(app)

value = app.DropDown.Value;

if value == 'Option 1'

counter=0;

app.EditField.Value = value;

% % INPUT THE FILE NAME AND DETAILS

[FileName,PathName] = uigetfile('*.xls','Select the Excel File','MultiSelect','on');

[num, txt]= xlsread([PathName,FileName{1,1}]);

[num1, txt1]= xlsread([PathName,FileName{1,2}]);

[m1,n1]=size(num);

[m2,n2]=size(num1);

a = txt(27:28,2);

is it correct way to read the excel data and excess the row and column data?

thank you!

[Stephen23]

"is it correct way to read the excel data and excess the row and column data?"

XLSREAD is deprecated, READTABLE / READCELL are recommended:

https://www.mathworks.com/help/matlab/ref/readtable.html

https://www.mathworks.com/help/matlab/ref/readcell.html

Answer 1

[Rahul]

Hi @garima,

The approach described by you for reading excel data into MATLAB AppDesigner appears to be in the right direction.

Some additions that can be considered are:

• Adding another Pushbutton, and using its callback to plot the accessed data.
• Adding edge-case error handling incase no file is selected by the user.

The following MATLAB Answers can be referred:

https://www.mathworks.com/matlabcentral/answers/1703590-reading-value-from-excel-file-in-app-designer/

https://www.mathworks.com/matlabcentral/answers/1819215-how-do-i-import-an-excel-file-into-app-designer

Hope this helps! Thanks.