How to show word from excel?

2 次查看（过去 30 天）
Eddy Iswardi
Eddy Iswardi 2020-3-28
评论： Eddy Iswardi 2020-3-29
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'

请先登录，再回答此问题。

采纳的回答

Peng Li
Peng Li 2020-3-28
编辑：Peng Li 2020-3-28
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 个评论
显示 15更早的评论
Walter Roberson
Walter Roberson 2020-3-29
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(:);
Eddy Iswardi
Eddy Iswardi 2020-3-29
thanks. you guys are very helpful. now I know how to manipulate views like this in the future.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by