Excel import single '

7 次查看（过去 30 天）
Simon
Simon 2011-9-6
Hi! Im trying to load an excel sheet using function xlsread. Some of its cells look like this: ‘900/8
i.e. with one single ‘ in the beginning. Nothing is loaded from these cells. Id prefer to fix this in Matlab using some other loading command. If its not possible, can I save my excel file in a smart format enabling loading of these cells. If that’s also impossible, can I remove the single ‘ in some way in Excel?
Thanx for your help, Simon

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

回答（1 个）

Oleg Komarov
Oleg Komarov 2011-9-6
So if you have an excel that look like this:
'900/8 30 20
'600/7 10 30
[num,txt] = xlsread(...);
Look at txt, your data is imported as class char and is stored in a cell array of strings. You have to convert them back to numeric class with:

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by