Effacer les filtres
Effacer les filtres

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

2 vues (au cours des 30 derniers jours)
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!

Réponses (0)

Produits


Version

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by