csvread (MATLAB Functions)

Read a comma-separated value file

Syntax

M = csvread('filename')
M = csvread('filename',row,col)
M = csvread('filename',row,col,range)

Description

M = csvread('filename') reads a comma-separated value formatted file, filename. The result is returned in M. The file can only contain numeric values.

M = csvread('filename',row,col) reads data from the comma-separated value formatted file starting at the specified row and column. The row and column arguments are zero-based, so that row=0 and col=0 specifies the first value in the file.

M = csvread('filename',row,col,range) reads only the range specified. Specify the range using the notation, [R1 C1 R2 C2] where (R1,C1) is the upper-left corner of the data to be read and (R2,C2) is the lower-right corner. The range can also be specified using spreadsheet notation as in range = 'A1..B7'.

Remarks

csvread fills empty delimited fields with zero. Data files having lines that end with a nonspace delimiter, such as a semicolon, produce a result that has an additional last column of zeros.

Examples

Given the file, csvlist.dat that contains the comma-separated values

   02, 04, 06, 08, 10, 12
   03, 06, 09, 12, 15, 18
   05, 10, 15, 20, 25, 30
   07, 14, 21, 28, 35, 42
   11, 22, 33, 44, 55, 66

To read the entire file, use

csvread('csvlist.dat')

ans =

     2     4     6     8    10    12
     3     6     9    12    15    18
     5    10    15    20    25    30
     7    14    21    28    35    42
    11    22    33    44    55    66

To read the matrix starting with zero-based row 2, column 0 and assign it to the variable, m,

m = csvread('csvlist.dat', 2, 0)

m =

     5    10    15    20    25    30
     7    14    21    28    35    42
    11    22    33    44    55    66

To read the matrix bounded by zero-based (2,0) and (3,3) and assign it to m,

m = csvread('csvlist.dat', 2, 0, [2,0,3,3])

m =

     5    10    15    20
     7    14    21    28

csch csvwrite