Spreadsheet (.xls) not fully loading
조회 수: 8 (최근 30일)
이전 댓글 표시
I'm importing a spreadsheet using
[data header] = xlsread(filename);
, but only the first 438 rows (13 elements/row) is imported. The file is 1500 rows long. Why isn't the entire file imported? What's imported is only 438*13*8 = 45kb, so clearly it's not a memory limitation...or is it? I'm running Ubuntu 12.04 64-bit, matlab 2014a, so the 'memory' command doesn't work.
댓글 수: 2
Star Strider
2014년 8월 7일
Can you open it in Excel?
If so, is there anything strange in or after row 438?
답변 (2개)
John
2014년 8월 7일
댓글 수: 5
dpb
2014년 8월 7일
Then probably it's related to not having Excel operating on the platform and the limits of the "basic" mode. You can always report bug and supply the file to TMW at www.mathworks.com and see if they can provide a workaround. Otherwise, as others have said, it would seem if you must use a spreadsheet as the generator you're limited to a text file interchange format. That the file seems to work on a Windows platform that (I presume) has Excel installed is what makes me think the "basic" mode issue is likely the problem.
Oh, can you try to remove and extra features or maybe functions/formulas and see if that helps? Save values only to another spreadsheet, maybe?
Kelly Kearney
2014년 8월 7일
편집: Kelly Kearney
2014년 8월 7일
I see the same behavior as John; biffparse (the basic xls reader) is returning NaNs at line 440 and fails to read beyond that. Not sure why, since biffparse is a mex file. Matlab 2013a on Mac OS X 10.9.3.
And in reply to the comment below, when not on Windows, reading from text files is always more stable (and usually quicker) than reading from Excel files. If your files are tab-delimited, just use dlmread or textscan.
azizullah khan
2014년 8월 7일
Save these files as CSV format
and use csvimport it will be better....
Or which type of OP system you are using?
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!