How to read data for button in app designer using MATLAB (2024)

function enterButtonPushed_3(app, tab, ElectionBox)

% Creating UILabel %

uilabel(tab, ...

'Text', 'Enter age grps for each Party:', ...

'Position', [40, 325, 350, 22]);

% Read Num of parties for current tab%

numParties = app.editFields(ElectionBox).Value;

% Create a 2D cell array to store age group for each party %

app.DynamicInputBoxes_2{ElectionBox} = cell(1,numParties);

initialPosition = [50, 320 , 50, 22];

% Iterate for each of the party %

for j = 1:numParties

initialPosition = initialPosition + [(j-1)*70,0,0,0];

numAgeGrps = app.DynamicInputBoxes_1{ElectionBox}(j).Value;

app.DynamicInputBoxes_2{ElectionBox,j} = gobjects(1,numAgeGrps);

% Dynamically create input boxes for each age group for each party %

for k = 1:numAgeGrps

fieldPosition = initialPosition +[0,-(k)*30, 0, 0];

app.DynamicInputBoxes_2{ElectionBox,j}(k) = uieditfield(tab,'numeric','Position', fieldPosition);

end

% In the end include a import from excel button to read age

% group data from excel file

if numAgeGrps > 0

uibutton(tab, 'push', ...

'Position', initialPosition + [0,-(numAgeGrps+1)*30,0,0], ...

'Text', 'Imp.Excel', ...

'ButtonPushedFcn', @(btn,event) fillDataFromExcel(app, ElectionBox, j));

end

end

end

function fillDataFromExcel(app, ElectionBox, partyId)

% Prompt User to select Excel File%

[file, path] = uigetfile({'*.xlsx';'*.xls'}, 'Select an Excel file');

if isequal(file,0) || isequal(path,0)

warning('Invalid File');

return;

else

excelFilePath = fullfile(path, file);

end

%Assuming a single column data in the excel file (As this

% function can be invoked for each party) %

data = readmatrix(excelFilePath, 'Range', 'A:A');

numAgeGrps = app.DynamicInputBoxes_1{ElectionBox}(partyId).Value;

% Checking data points of input boxes vs Excel column %

if numAgeGrps ~= numel(data)

warning('The number of data points in the Excel file does not match the number of input boxes.');

end

% Filling in the Data %

for k = 1:min(numAgeGrps, numel(data))

app.DynamicInputBoxes_2{ElectionBox, partyId}(k).Value = data(k);

end

end

• Link

  Direct link to this comment

  https://in.mathworks.com/matlabcentral/answers/2107681-how-to-read-data-for-button-in-app-designer-using-matlab#comment_3134261