Excel import single '
显示 更早的评论
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
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:
类别
在 帮助中心 和 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 
