How to add text and numbers to gui table?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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.
0 Kommentare
Antworten (1)
Cris LaPierre
am 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);
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!