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');
精彩评论