Using MATLAB to load the dimensions of an object selected by the user from an excel file

I have an excel file with the dimensions of different cylinders. How can I use MATLAB so that the user selects a particular cylinder from a drop down list and then the dimensions of this cylinder are then loaded into matlab for further calculation?

Answer 1

[Rahul]

Hi @Mech130180,

In order to read the data from excel into matlab, consider using 'readtable' function.

Additionally, consider using 'uidropdown' function to obtain the required dropdown functionality within a 'uifigure' and integrate it with a 'ValueChangedFcn' callback.

Here is an example:

% Read the excel data
data = readtable('Book2.xlsx');

% Here I have assumed that the Excel file has columns: 
% 'CylinderName', 'Diameter', 'Height' - This can be adjusted accordingly
cylinderNames = data.CylinderName;

% Create the user interface
fig = uifigure('Name', 'Select a Cylinder');
dropdown = uidropdown(fig, ...
    'Items', cylinderNames, ...
    'Position', [100, 150, 150, 22], ...
    'ValueChangedFcn', @(dd, event) loadCylinderDimensions(dd, data));

% Callback function to load dimensions (This can be adjusted according to user requirements) 
function loadCylinderDimensions(dd, data)
    selectedCylinder = dd.Value;
    idx = strcmp(data.CylinderName, selectedCylinder);
    fprintf('Selected Cylinder: %s\n', selectedCylinder);
    fprintf('Diameter: %.2f\n', data.Diameter(idx));
    fprintf('Height: %.2f\n', data.Height(idx));
    
end

The following MATLAB Answers can also be referred:

https://www.mathworks.com/matlabcentral/answers/225110-how-to-load-and-read-excel-data-into-matlab

https://www.mathworks.com/matlabcentral/answers/2109246-how-to-detect-programmatically-induced-value-changes-of-uidropdown

The following MathWorks documentations can be referred to know more:

'readtable': https://www.mathworks.com/help/matlab/ref/readtable.html

'uidropdown': https://www.mathworks.com/help/matlab/ref/uidropdown.html

Hope this helps. Thanks.