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

조회 수: 2 (최근 30일)
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!

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by