Spreadsheet (.xls) not fully loading

Question

John 2014-8-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/146614-spreadsheet-xls-not-fully-loading

编辑： Kelly Kearney 2014-8-7

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 个评论
显示无隐藏无

dpb 2014-8-7

More than likely there's something bum in the file at that point

Star Strider 2014-8-7

Can you open it in Excel?

If so, is there anything strange in or after row 438?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

John 2014-8-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/146614-spreadsheet-xls-not-fully-loading#answer_147795

dataTest.xls

There isn't anything strange in the file, i wrote the lines manually in LibreOffice calc. See attachment.

5 个评论
显示 3更早的评论隐藏 3更早的评论

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.

请先登录，再进行评论。

Answer 2

azizullah khan 2014-8-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/146614-spreadsheet-xls-not-fully-loading#answer_147805

Save these files as CSV format

and use csvimport it will be better....

Or which type of OP system you are using?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

John 2014-8-7

As mentioned in the original post, Ubuntu 12.04 64-bit, matlab 2014a. How is cvsimport() better than xlsread()? And if the actual raw files are TSV (tab separated) is there a better way to do import them?

请先登录，再进行评论。