How I can read a CSV file with header?

2 次查看（过去 30 天）
Hildo
Hildo 2015-6-18
回答： Hildo 2016-11-25
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.

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

采纳的回答

Hildo
Hildo 2016-11-25
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},',','.');

更多回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by