Importing / Xlsread: How to replace unknown character?

3 次查看（过去 30 天）
Hampus
Hampus 2017-5-3
评论： Hampus 2017-5-4
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.

请先登录，再回答此问题。

回答（1 个）

Santhana Raj
Santhana Raj 2017-5-4
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.

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by