Read certain range of csv file

Question

Bryan 2012-8-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/45149-read-certain-range-of-csv-file

评论： Matlaber 2019-2-15

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Eric 2012-8-3

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/45149-read-certain-range-of-csv-file#answer_55368

编辑：Eric 2012-8-3

在 MATLAB Online 中打开

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