Excel reading - xlsread
显示 更早的评论
Hello i want to read some data from Excel worksheet. When i use "xlsread" some of the cells isn't readen by Matlab. For example a,b,c,d, etc. columns (4 to 11th columns)can be read, but name date and time columns (first three columns) can't be read in my example below.
How can i fix this without changing so much in excel worksheet?
采纳的回答
Andy
2011-5-17
Use the third output of xlsread:
[data, txt, raw] = xlsread(...);
The "raw" output is a cell array which contains all of your data.
3 个评论
Oleg Komarov
2011-5-17
What if I edit so that the answers are the same (devil)...
Andy
2011-5-17
I suppose in retaliation I would have to write a bot which follows your answers and duplicates them, stealing (expected) half of your future reputation. ;)
On a related note, it would make an interesting future MATLAB contest to write a MATLAB Answers bot which generates the highest reputation in a given time period.
Walter Roberson
2011-5-27
Reputation depends upon human subjectivity, and so is probably not suitable for a bot contest.
更多回答（1 个）
Oleg Komarov
2011-5-17
Use the second output of xlsread.
[data, text] = xlsread(...);
The first three columns and the first row is interpreted as char type and you cannot mix doubles with chars.
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
2011-5-17
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
