Read certain range of csv file

Hi,

I want to load a .csv file, but only the content between A252 to D5352.

I've looked at help csvread, and it says I can load files using spreadsheet notation, but the help file is quite vague on this and no example is given.

I've tried

file = csvread('file.csv',A252,D5352,range);

file = csvread('file.csv',0,0,'A252..D5352');

any many other permuatations, but I can't get it to function.

Anybody who has done this before and got it to work?

Thanks Bryan

Answer 1

[Eric]

There are several ways to do this:

1. Using csvread:

   data = csvread('file.csv',251,0,'A252..D5352');

2. Using dlmread (which is what csvread actually calls)

   data = dlmread('file.csv', ',', 251, 0, 'A252..D5352');

3. Using xlsread (Excel reads CSV files easily):

   data = xlsread('file.csv', 'A252:D5352');

The trick with csvread and dlmread is that the r and c inputs must be consistent with the range that is passed in as a string at the end. Remember that these parameters are zero-based, so that column A maps to 0 and row 252 maps to 251.

Regards,

Eric

[Matlaber]

This is very helpful. Thanks.

Answer 2

[John Petersen]

Try

file = csvread('file.csv', 251, 0, [251 0 5351 5351+n]);

where n is the number of columns you want to read

Answer 3

[Bryan]

Thanks for your comment.

Yes, that would work. But has anybody had success getting the "spreadsheet notiation" to work, as mentioned on the help file for csvread?