How to add text and numbers to gui table?

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.

Answer 1

[Cris LaPierre]

See these examples on the uitable documentation page. Basically, if you have mixed data types, either use a table or a cell array.

• Display Table Array Data
• Display Mixed Data Types

Here's how I might do it

T = readtable("Pattern Balancing.xlsx","VariableNamingRule","preserve")
fig = uifigure;
uit = uitable(fig,'Data',T);