Importing data from excel file into column arrays

1 次查看（过去 30 天）
Konstantinos Belivanis
Hello all,
I would like to import data from my excel file (Say data.xlsx) to many arrays into Matlab. I tried to do it with the import option but I get many NaN (Not a Number) arrays.
What I would like to do is import all the columns of length of the first column. I would like the name of the array to be the text in the 5th row of each column and the numbers to start from the 6th row. Also I would like blank cells to be input as zero values after importing.
Any idea?

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

回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by