Why can't I import the following file using the following command?

When I type:

>> b = readtable('24198 1A 1.tif_8.csv');

I have no errors and the table is imported nicely.

When I type:

>> b = readtable('24198 1A 1.tif_9.csv');

I get:

Error using textscan Out of memory. Type HELP MEMORY for your options.

Error in table/readTextFile (line 160) raw = textscan(fid,format,'delimiter',delimiter,'whitespace',whiteSpace, ...

Error in table.readFromFile (line 41) t = table.readTextFile(filename,otherArgs);

Error in readtable (line 114) t = table.readFromFile(filename,varargin);

I can't seem to understand why this happens. I have tens of these cdv files and all import fine except for 24198 1A 1.tif_9.csv.

Why?

[Alessandro Masullo]

The error is Out of memory, how big is the file you are trying to open?

Answer 1

[Star Strider]

I can’t reproduce the error with:

b = readtable('24198 1A 1.tif_9.csv');

It imports and creates the table without problems in R2014b.

It’s an Excel-formatted file, so see if:

[d,s,r] = xlsread('24198 1A 1.tif_9.csv');

works for you.

[Dale]

This gives error:

>> [d,s,r] = xlsread('24198 1A 1.tif_9.csv');

Error using xlsread (line 248) Unable to read XLS file /24198 1A 1.tif_9.csv. File is not in recognized format.

Also, I am using R2013b. Could this be a problem?

[Star Strider]

It could be. I don’t imagine there would be significant version differences, but there could be.

Can you open it in Excel (outside of MATLAB) by clicking on it?

I’m out of ideas otherwise, since I can’t reproduce the problem.

Answer 2

[Image Analyst]

You're missing a column header for the first column. Try this to ignore that.

t = readtable('24198 1A 1.tif_9.csv', 'readRowNames', true);

[Dale]

Still the same error:

>> b = readtable('24198 1A 1.tif_9.csv', 'readRowNames', true); Error using textscan Out of memory. Type HELP MEMORY for your options.

Error in table/readTextFile (line 160) raw = textscan(fid,format,'delimiter',delimiter,'whitespace',whiteSpace, ...

Error in table.readFromFile (line 41) t = table.readTextFile(filename,otherArgs);

Error in readtable (line 114) t = table.readFromFile(filename,varargin);

[Image Analyst]

I tried it again with my lowly 8 GB RAM memory, i5-CPU computer and it ran fine and loaded a 45x45 table. Are you sure you gave us the full file and not a smaller subset?