xlsread import empty cell from excel file

Question

wessel ter Laare 2020-8-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/582236-xlsread-import-empty-cell-from-excel-file

评论： wessel ter Laare 2020-8-21

Good day,

I have created a script where I run through various excel files stored in a folder, and import certain areas into Matlab. As per below short example:

Test_files = dir([SourceFolder '*.xlsx']);
No_of_Tests = size(Test_files,1);
for n = 1:No_of_Tests
    Test_filename = Test_files(n).name;
    X(n,:) = xlsread(Perf_filename,'TEST','D101'); %Parameter 1
end

In some instances the field in the excel file is left blank. At that time my script crashed.

How can I make xlsread import an empty cell as NaN or Blank or something similar?

Thanks in advance for your kind assistance.

Rgrds,

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

dpb 2020-8-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/582236-xlsread-import-empty-cell-from-excel-file#answer_482801

编辑：dpb 2020-8-20

在 MATLAB Online 中打开

Can't that way... xlsread imports what it finds as numeric and an empty cell is not numeric. You could use the multiple optional returns and read the raw cell that (I think, untested) will return an empty cell.

Probably the easiest kludge to fix your problem is

Test_files = dir([SourceFolder '*.xlsx']);
No_of_Tests = size(Test_files,1);
for n = 1:No_of_Tests
  try
    X(n,:) = xlsread(Test_files(n).name,'TEST','D101'); 
  catch
    X(n)=nan;
  end
end

But, per the doc xlsread is deprecated, anyways; use one of the suggested alternates (altho even there you may have trouble with a single empty cell expecting numeric result).