IllegalArgumentException when using parsing CSV using apache commons csv - CSVFormat

Question

I am parsing a CSV file using Apache commons CSV using the following code:

CSVFormat csvFileFormat = CSVFormat.EXCEL.withHeader().withQuoteMode(QuoteMode.MINIMAL);

On some of the CSV files I am getting the following error:

java.lang.IllegalArgumentException: 
Mapping for Phone number not found, 
expected one of [Address, City, State, Zip, Phone Number, Product, Comments/Description, Final Status, Date Closed]

I checked the file, it contains a"Phone Number" column, column exist and all the values present.

what am I doing wrong?

Export the file from Excel to TEXT (CSV or whatever), then look at the raw data (using Notepad++ perhaps) to see if anything is weird. You could have stray CR/LF characters or stray quotes (only one quote without the finishing quote) or lots of errors in actual CSV format. Excel is renowned for this. If you try to IMPORT that TEXT file into MySQL or SQL Server - it will probably give you a better error with the line number — Grantly
– Grantly, Commented Dec 12, 2017 at 22:06
There is a difference in case, "number" vs "Number" in your question, maybe this is causing problems? — centic
– centic, Commented Dec 13, 2017 at 6:00
this is correct centic, there is a feature on this issues.apache.org/jira/browse/CSV-159 please have this as an answer so i can accept it. — JavaSheriff
– JavaSheriff, Commented Dec 13, 2017 at 14:54

Ashwani Sharma · Accepted Answer · 2018-12-04 07:30:10Z

1

According to your exception message the n of Phone number is small but the field contains it in Phone Number form. The error will not arrive when it will found a column named in the above message.

answered Dec 4, 2018 at 7:30

Ashwani Sharma

5091 gold badge8 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

IllegalArgumentException when using parsing CSV using apache commons csv - CSVFormat

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related