how to export an excel data into matlab with row header in between

1 次查看(过去 30 天)
I have very large data (100000 by 2 )which looks like the following:
*CN*
10.598 1.890
11.222 -5.369
-10.256 11.235
14.589 15.888
. .
. .
*CN*
20.359 14.523
6.256 9.124
. .
. .
The 100000 column is divided into 35 parts by column header(CN)in the second column represent the number of column that follows ( for example the first CN is 10, the second is 25 and so on). My target is to multiply column one and column two and at last i have 100000 by 1 matrix including CN.
Could you please tell me how can i do that. I attached also sample file. Thanks.

回答(0 个)

类别

Help CenterFile 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