Reading value from Excel file in App Designer

조회 수: 5 (최근 30일)
Muhammad Nabil Mohd Pauzi
Muhammad Nabil Mohd Pauzi 2022년 4월 24일
답변: Kevin Holly 2022년 4월 25일
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.

답변 (1개)

Kevin Holly
Kevin Holly 2022년 4월 25일
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');

카테고리

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

태그

제품


릴리스

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by