Reading value from Excel file in App Designer

22 visualizzazioni (ultimi 30 giorni)
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.

Risposte (1)

Kevin Holly
Kevin Holly il 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');

Categorie

Scopri di più su Develop Apps Using App Designer in Help Center e File Exchange

Prodotti


Release

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by