How to delete multiple rows from an excel file?

Question

Be 2014-9-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/153286-how-to-delete-multiple-rows-from-an-excel-file

评论： Be 2015-4-2

Hi,

I am (very) new to Matlab and am having real trouble with importing an excel file.

I have an extremely large excel file that has text, numbers and date/ times that all need importing. There are 25 columns and 104485 rows. When I import it using the import tool it returns everything with an NaN. I think this is because some of the rows have not got correctly formatted values in them and have a text value (as far as I can see it's \N).

So, what I need to do is remove all of the rows where this is occurring so I can import the rest of the data correctly.

NB. I have another data set that is exactly the same layout that does not have dodgy data in some of the rows and that imports perfectly with no issues at all.

Any help would be much appreciated as I'm really struggling here!

Thank you in advance!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2014-9-3

Besides the answer of Yona which is generally good advice to use xlsread and post-process, I'd suggest showing a small subsection of the file that illustrates the form of the data so others can look--there may be other things that can be done, depending...

请先登录，再进行评论。

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

Answer 1

Yona 2014-9-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/153286-how-to-delete-multiple-rows-from-an-excel-file#answer_150603

编辑：Yona 2014-9-4

when you import data by xlsread function, you get 3 matrix. one of numbers, one of text and one with both of them and it is a cell matrix.

when you import file:

in number matrix you get all column that have at least one number and all text and empty cell is NaN.
In text you get all column that have at least one text and all number is '' (empty string).
In cell matrix you get all data and all empty cell are NaN.