How to add text and numbers to gui table?

12 views (last 30 days)
Ahmed Roshbik
Ahmed Roshbik on 1 Jul 2021
Answered: Cris LaPierre on 1 Jul 2021
i want to get data from excel file with two columns the first one is text data and the second one is numeric data
Pattern VD (mmbbl)
A 4
B 3
C 5
D 6
E 2.6
F 3.6
i tried changing the values to string but the table didn't read them, the code i did
[x,txtData]=xlsread('Pattern Balancing.xlsx','B:B');
c=string(cell2mat(txtData));
y=xlsread('Pattern Balancing.xlsx','C:C');
z=[c y]
set(handles.uitable1,'data',z);
where :
x = Pattern
y = VD
Thank you in advance.

Answers (1)

Cris LaPierre
Cris LaPierre on 1 Jul 2021
See these examples on the uitable documentation page. Basically, if you have mixed data types, either use a table or a cell array.
Here's how I might do it
T = readtable("Pattern Balancing.xlsx","VariableNamingRule","preserve")
fig = uifigure;
uit = uitable(fig,'Data',T);

Categories

Find more on Migrate GUIDE Apps in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!