Find empty cells in excel

Question

John Rebbner 2018-11-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/429832-find-empty-cells-in-excel

回答： Surendra Reddy Kovvuri 2021-3-26

Hi! I am trying to read data from a specific column in excel, but want to stop my code when it meets an empty

Here is my code:

   [~,~,raw] = xlsread('file_name');
    if isempty(raw(6,1)) == 1
       disp('empty')
   else
       disp('non-epmty')
    end

And evry time the code displays 'non-empty' even though the cell raw(6,1) is filled.

Any suggestions why ???

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

Stephen23 2018-11-14

Note that putting

== 1

does nothing. Get rid of it.

请先登录，再进行评论。

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

Answer 1

Stephen23 2018-11-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/429832-find-empty-cells-in-excel#answer_346904

编辑：Stephen23 2018-11-14

You used the wrong kind of indexing. You need to use curly braces:

isempty(raw{6,1})
           ^   ^
           

The difference is simple:

() parentheses access the cells themselves.
{} curly braces access the cell contents (which is what you want to check).

2 个评论
显示无隐藏无

John Rebbner 2018-11-14

Thank you! I've changed the code as you show me, but it seems as there is no difference because I change raw{6,1} which is a filled cell and for instance raw{10,1} is empty and the answer is 0 every time.

Stephen23 2018-11-14

@John Rebbner: If the cell is not empty then you should check the actual content of that cell. It might contain an empty string or something else the Ecxel something puts in cells. If you upoad your file then someone can help you with that.

请先登录，再进行评论。

Answer 2

Guillaume 2018-11-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/429832-find-empty-cells-in-excel#answer_346981

Have you checked what the content of raw actually is for cells that are empty in excel? In my version of matlab (2018b) with my version of excel (office 365), an empty excel cell is translated to NaN not an empty array in matlab, so testing for emptiness is not going to succeed. Testing for NaN would have more success (with isnan)