loading excel in 'basic' mode

1 回表示 (過去 30 日間)
Trevor Harris
Trevor Harris 2013 年 3 月 20 日
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 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by