According to the Javadoc of CSVFormat
- CSVFormat.DEFAULT includes among its settings withIgnoreEmptyLines(true)
- CSVFormat.EXCEL includes among its settings withIgnoreEmptyLines(false)
- Then, the same documentation of CSVFormat.EXCEL reads that
Note: this is currently like RFC4180 plus withAllowMissingColumnNames(true).
One of these three must be wrong (both ignore empty lines, or neither ignores empty lines, or there is another difference that needs to be mentioned).
Edit: after checking the source code, I conclude that the latest sentence is incomplete, and should also mention withIgnoreEmptyLines(false) as a difference with DEFAULT