CODEWITHSUNDEEP
imageexcelmatlab
qurada'a
qurada'a

Reputation: 41

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.
> 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

Upvotes: 4

Views: 1817

Answers (2)

Sam
Sam

Reputation: 1

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');

Upvotes: 0

fdermishin
fdermishin

Reputation: 3686

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)

Upvotes: 3

Related Questions