How I extract specific columns and lines?

20 次查看（过去 30 天）

Danai Varvatsouli 2020-5-14

评论： darova 2020-5-14

I have an excel file with a table 1442x31 and I want to extract specific columns and lines.

For Example I want to make a new table named a where I want to insert: all values from 109 until 210, from columns 3-20.

2 3 4 5 6 7 8
a b c d e f g
a b c d e f g
a b c d e f g
a b c d e f g
a b c d e f g
a b c d e f g
a b c d e f g

Let's say I want all values from 3rd column but only on lines 4,5,6,7

How do I do that?

darova 2020-5-14

Try

A1 = A(109:210,3:20);

read about colon

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by