Identifying blocks of data in excel data input

1 次查看（过去 30 天）
Saeid
Saeid 2018-1-16
I need to read data from large excel files that are composed of smaller blocks that are typically separated by free spaces and have different numbers of rows (but for now, the same nubers of columns).
The data is composed both of numbers and strings, so I usually read the whole set in raw format using:
[NUMM,STRR,RAWW]=xlsread(InFile,1)
Then I perform the required operations on them. However, I need to separate the data into smaller blocks (and subsequently, separate arrays) as shown in figure and treat each block differently, so that I will have arrays by names YellowMatrix, RedMatrix, OrangeMatrix, BlueMatrix etc. How can I do this without using a loop?

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

回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by