How to show word from excel?
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
Peng Li
on 28 Mar 2020
Edited: Peng Li
on 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 Comments
Walter Roberson
on 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(:);
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB 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!