Read certain range of csv file
조회 수: 84 (최근 30일)
이전 댓글 표시
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
채택된 답변
Eric
2012년 8월 3일
편집: Eric
2012년 8월 3일
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
추가 답변 (2개)
John Petersen
2012년 8월 2일
Try
file = csvread('file.csv', 251, 0, [251 0 5351 5351+n]);
where n is the number of columns you want to read
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!