Missing values in cell array/ cellfun deltes space in Strings

Question

Tim Krzyzanowski 2022-5-24

回答： Hiro Yoshino 2022-5-24

Hi everyone,

I am facing a problem with the cellfun function.

So first of all what i am doing.

I read in a excel file with the readcell function.

Thisis then a cell array mixed with strings and numbers. But also with some empty lines which leads to lines with 1x1 missing inside.

So i did the fix suggested from here and added this line under my read in:

param_table = cellfun(@rmmissing, param_table, 'UniformOutput', false);

But unfortunatly this code is deleting my spaces in the Strings: For example it changes Cell{2,2} from 'Simple text' to 'Simpletext'

Answer 1

Hiro Yoshino 2022-5-24

You could read your excel by using app.

Go to MATLAB >> Home >> Import Data >> Import as table.

If you want to have more control of this import, you can generate the corresponding MATLAB code automatically from the App.