Hi everyone! I'm trying to modify a code generated by the import tool, thus making the code more flexible with respect to changes in the original Excel file.
The autogenerated code states:
raw(cellfun(@(x) ~isempty(x) && isnumeric(x) && isnan(x),raw)) = {''};% Find row with blank cells
I = any(cellfun(@(x) isempty(x) || (ischar(x) && all(x==' ')),raw),2); raw(I,:) = [];
This excludes rows with even a single blank cell. I want to import the whole Excel sheet and then exclude fully blank rows, how can I achieve this?
Thanks
Best Answer