MATLAB: Remove last row from csv using csvread

csvread

Hi, I have the following code to read all the csv files in a directory.
close all;
csvfiles = dir('*.csv');
for file = csvfiles'
    datafromfile = csvread(file.name, 17, 0);
    freq = datafromfile(:,1);
    power = datafromfile(:,2);
end
However, the csv files contain a cell with END in the last cell, as follows. This results in an error when the script runs. 
HEADER    HEADER    HEADER
HEADER    HEADER    HEADER  
29950250  3.46649905459066  0  0  0
30000000  5.23598452822347  0  0  0
END
How can I remove the last element/row from the csv so the script runs?
EDIT: I've included an example csv file.

Best Answer

If you must use csvread() and you know the rows and columns of the file that should be read, use the following syntax to limit the section of the file that is read into Matlab.
M = csvread(filename,R1,C1,[R1 C1 R2 C2]) r
However, if you're using a recent release of Matlab, consider using readtable() instead of csvread().
Related Question