How to read multiple columns with same name

[chiragrlti]

I have 2 columns in my excel with column name "Addr line1" (one for source and one for dest address). how should i read them?

[millij]

@chiragrlti
At this moment, the Reader implementations expects one-to-one mapping between columns and Java Class properties.
Having 2 columns with the same name doesn't satisfy the current expectation.

One workaround is, change the column name and read it.

[millij]

Potential Solution is to allow SheetColumn annotation to accept Column index as an alternate to Column name.

Pro: More flexible API, i.e., supports both Column name mapping as well as index based mapping
Con: Strongly depends on the order of the Columns. Object property to excel column mappings get invalid whenever the column order changes.

Will take it up as feature request for future releases.

[justhyno]

i had this issue too, i want read two column with same name