How to show word from excel?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I want to show the word from excel. But I don't know how to show it. This is my code.
clc;
clear all;
T=readtable('EVASUSANTIDATA.xlsx');
x1=T.PENDAFTARAN;
x2=T.TUNDA;
x3=T.KUOTA;
y=T.LAMA;
For example, I want to get this result:
KOTA KUOTA LAMA
KOTA BENGKULU 311 21
it's the data number one in excel. With 'KUOTA' is 'x3' and 'LAMA' is 'y'
0 commentaires
Réponse acceptée
Peng Li
le 28 Mar 2020
Modifié(e) : Peng Li
le 28 Mar 2020
subT = T(T.NO == 1, [2 5 6]);
Will be the first record with the 2nd 5th and 6th variable as a new table.
17 commentaires
Walter Roberson
le 29 Mar 2020
In the code
T(1:4, [2 5 6])
The [2 5 6] does not refer to values of KUOTA that are to be matched: the [2 5 6] refers to column numbers in the table. So when you were talking about T(1:4, [2 d 6]) then you were talking about extracting a different set of column numbers.
Anyhow:
nT = T(1:4, [2 5 6]);
nT{:,2} = d(:);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!