Reading value from Excel file in App Designer

23 Ansichten (letzte 30 Tage)
Muhammad Nabil Mohd Pauzi
Muhammad Nabil Mohd Pauzi am 24 Apr. 2022
Beantwortet: Kevin Holly am 25 Apr. 2022
I am trying to read the value in a specific cell (say, A2) in an Excel file and use this value as the input of a numeric field in app designer. Can I know how I can do this? Cheers.

Antworten (1)

Kevin Holly
Kevin Holly am 25 Apr. 2022
Please see the app attached. I used uigetfile to select the file and then xlsread to extract the value of interest from the Excel file. I would use readcell in the latest releases of MATLAB.
[filename, folder] = uigetfile('*.xls*');
app.EditField.Value = xlsread(fullfile(folder,filename),1,'A2');

Kategorien

Mehr zu Develop Apps Using App Designer finden Sie in Help Center und File Exchange

Produkte


Version

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by