MATLAB Answers

Importing / Xlsread: How to replace unknown character?

6 views (last 30 days)
Hampus
Hampus on 3 May 2017
Commented: Hampus on 4 May 2017
clearvars;
filename = 'ABB';
[ num,txt,raw ] = xlsread( char(filename) );
Problem with above: how do I replace an unknown character, i.e. a character that's not in the English language when importing from an Excel-file?
E.g. the Swedish letter ö? When I'm screening the document through Matlab I just see a question mark.

Answers (1)

Santhana Raj
Santhana Raj on 4 May 2017
Instead of using xlsread, use readtable.
one of its options is fileEncoding. I am sure it can read Swedish, but you can explore in that direction.
another suggestion is to replace '?' with space after reading the whole xls file.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!