loading excel in 'basic' mode
1 次查看(过去 30 天)
显示 更早的评论
Morning all,
I'm trying to load an excel sheet in basic mode, basically because it's super fast when compared to the alternative. The issues is, is that once the sheet becomes large & contents of the cells become large it fails to import things correctly.
Digging through the code of xlsread, it parses the input and if I require "basic" it jumps to a sub-routine called xlsreadBasic (xlsreadCOM is the non-basic version, which functions fine for the sheet I wish to import btw).
Within the xlsreadBasic, there are tow functions called biffread and biffparse. biffread loads files as uint8, which I suspect is the deficiency. When I load the sheet I end up with values in this loaded vector that are greater than 255, which is the smoking gun. The cells must be beyond the capability of uint8. Fine, I'll use fread and load them as uint16, which I did successfully, which brings me to my question.
The biffparse, I cannot replicate for an uint16 vector, simply because I can't find the sub-routine. When I right click on it and say "open" it cant find the sub-routine, but stepping through the program, it functions. What gives? Any suggestions to either my approach or how to proceed from here?
Trevor
0 个评论
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!