MATLAB Answers

How to show word from excel?

1 view (last 30 days)
Eddy Iswardi
Eddy Iswardi on 28 Mar 2020
Commented: Eddy Iswardi on 29 Mar 2020
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'

Accepted Answer

Peng Li
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
Eddy Iswardi
Eddy Iswardi on 29 Mar 2020
thanks. you guys are very helpful. now I know how to manipulate views like this in the future.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!