How I can read a CSV file with header?

How I can read one CSV file with header, semicolon to separate the column and coma to float point? One example is annex. I try use the importdata, csvread and dlmread.

[Star Strider]

Use the xlsread function if you have Excel.

Answer 1

[Hildo]

The better way was use the textscan function with ";" delimiter and after replace the "," by "." before the conversion of string to number.

fileID = fopen(filename,'r');
startRow = 10;
dataArray = textscan(fileID,'%s%s%s',inf,'Delimiter',';',...
    'HeaderLines', startRow-1,'ReturnOnError', false);
fclose(fileID);
dataArray{1,2} = strrep(dataArray{1,2},',','.');
dataArray{1,3} = strrep(dataArray{1,3},',','.');

Answer 2

[Azzi Abdelmalek]

[a,b,c]=xlsread('PV-20150616.csv')
out=b(8:end,:)