See previous Answer at https://www.mathworks.com/matlabcentral/answers/95270-why-does-xlsread-not-replace-empty-cells-by-nan-when-the-cells-appear-at-the-end-of-the-range-in-m?s_tid=answers_rc1-1_p1_MLT
You might want to investigate using the new(ish) table class and readtable as alternative.
