MATLAB: Readcell is filling cell locations with “1×1 missing”

MATLABxlsread

I am using R2109a and it is recommended to use readcell instead of xlsread. Readcell is slower than xlsread and it is returning "1×1 missing" instead of an empty cell when reading an .xlsx file. I don't know what logical I can use to remove these cell locations without brute forcing the problem. Does anyone else know what I can do to fix this?
Capture.PNG

Best Answer

If your data (excluding header) is purely numeric, you'd be better off using readmatrix instead of readcell. If your date is heterogeneous you'd be better off using readtable. The matrix/table will use less memory than a cell array and more crucially make it very easy to remove rows with <missing> entries with rmmissing.
t = rmmissing(readtable(youfile))
With a cell array, rmmissing will only work if the cell array only contain char vectors.
Related Question