Use isnan with input excel data containing a combination of strings and empty cells in a row
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Saeid
am 17 Jun. 2019
Beantwortet: Alex Mcaulley
am 17 Jun. 2019
When I read raw data from an excel file named INFILE.xls, I usually want to remove the free spaces between columns afterward and have a string array composed only of the existng text.
[num, str, raw]=xlsread(INFILE)
samplerow=raw(1,:)
The result is:
{'first string'} {'second string'} {[NaN]} {[NaN]} {[NaN]} {[NaN]} {'third string'} ...
I would like to then have a string array like this:
strArray={'first string'} {'second string'} {'third string'} ...
If I try to find and remove the NaN elements using isnan I receive the error message
All contents of the input cell array must be of the same data type.
How can I work aorund this?
0 Kommentare
Akzeptierte Antwort
Alex Mcaulley
am 17 Jun. 2019
If you just want the text:
[num, str, raw] = xlsread(INFILE)
samplerow = str(1,:);
samplerow(cellfun(@isempty,samplerow)) = [];
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!