csv-commons - withSkipHeaderRecord option doesn't skip anything

Question

I have usual csv file with header

f1, f2, f3
1, 2, 3

and I try to parse it:

 Iterable<CSVRecord> records = CSVFormat.EXCEL.withIgnoreEmptyLines().withSkipHeaderRecord().parse(in);
            records.forEach(record -> {
               ...

But anyway the first record is header anyway.

What do I wrong?

SVK PETO · Answer 1 · 2020-05-27T14:19:26.913

6

specify that file have header to skip:

CSVFormat.EXCEL.withHeader().withSkipHeaderRecord();

edited May 27 '20 at 14:19

answered May 27 '20 at 14:13

SVK PETO

115
1
8

1

With v1.9.0 it is now slightly different CSVFormat.EXCEL.builder().setHeader().setSkipHeaderRecord(true) – Olivier Tonglet Jun 22 '22 at 11:32

score 2 · Answer 2 · answered Nov 09 '17 at 20:46

2

I know, right? Say you had a bowl full of green, brown and red M&Ms. And you decided to skip the blue ones. Do you see where I'm going with this? You don't have a header record.

Try .withFirstRecordAsHeader(). I think you'll be pleased.

answered Nov 09 '17 at 20:46

Ion Freeman

512
4
19

score 0 · Answer 3 · answered Mar 24 '19 at 23:00

I think what Ion Freeman wants to say is that you can skip the header if you first state that the first line is the header like so: (not tested).

 Iterable<CSVRecord> records = CSVFormat.EXCEL.withIgnoreEmptyLines().withFirstRecordAsHeader().withSkipHeaderRecord().parse(in);

In my case, that wasn't possible because I had an invalid header with duplicates. I had to remove it via another way. I threw it away by reading the first line.

in.readLine();  // in = BufferedReader or an other Reader
records.forEach(record -> {
...

csv-commons - withSkipHeaderRecord option doesn't skip anything

3 Answers3