开发者

Error reading large Microsoft Excel files using XLSREAD in MATLAB 7.0.1 (R14SP1)

I have an Excel file. When I am trying to access a single sheet using the following command:

x=xlsread('CS_7_1800_rerun.xls',1);

I receive the following error:

Warning: See help sprintf for valid escape sequences.
&开发者_JS百科gt; In iofun\private\validpath at 59
> In xlsread at 187
??? XLSREAD unable to open file CS_7_1800_rerun.xls.
Error using ==> iofun\private\validpath

I use MATLAB 7.0.0.1


Yes, it seems that it is a bug in MATLAB

There is a bug in MATLAB 7.0.1 (R14SP1) that affects the way XLSREAD handles large Excel files. The only workaround is to break the larger file into a number of smaller files.(mathworks.com)


I had the same problem with trying to use xlsread to import a large 6000+ row by 2000+ column xlsx file. So I removed all text from my file, saved the file in the Text (Tab delimited) format. Then I had success using the following code.

A=dlmread('c:\testdata1.txt','/t');
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜