Get CSV file header using apache commons

java csv apache-commons-csv
user3382344 picture user3382344 · Mar 28, 2016 · Viewed 16.8k times · Source

I have been looking for the past 2 hours for a solution to my problem in vain. I'am trying to read a CSV File using Apache commons ,I am able to read the whole file but my problem is how to extract only the header of the CSV in an array?

Answer

Darshan Mehta picture Darshan Mehta · Mar 28, 2016

By default, first record read by CSVParser will always be a header record, e.g. in the below example:

CSVFormat csvFileFormat = CSVFormat.DEFAULT.withHeader(FILE_HEADER_MAPPING);
FileReader fileReader = new FileReader("file");
CSVParser csvFileParser = new CSVParser(fileReader, csvFileFormat);
List csvRecords = csvFileParser.getRecords();

csvRecords.get(0) will return the header record.

Related questions

Java - Write CSV File with Apache.commons.csv

I'm using the apache.commons.csv library in Java. I'm reading a CSV file from a web page with this code: InputStream input = new URL(url).openStream(); Reader reader = new InputStreamReader(input, "UTF-8"); defaultParser = new CSVParser(reader, CSVFormat.DEFAULT); excelParser = …

Read More
No header mapping was specified, the record values can't be accessed by name (Apache Commons CSV)

I got this error message happening when I'm trying to read a csv: Exception in thread "main" java.lang.IllegalStateException: No header mapping was specified, the record values can't be accessed by name at org.apache.commons.csv.CSVRecord.get(…

Read More
How can I skip the first line of a csv in Java?

I want to skip the first line and use the second as header. I am using classes from apache commons csv to process a CSV file. The header of the CSV file is in the second row, not the first (…

Read More