Hi members:
An user excel file contains leading and trailing spaces in some of the
column headers.
Examples: " January ", " January"
As consequence the resulting imported rows are set as 0.
Is there any means in the excel module that alows me to pre-trim those
headers before the row bind happens?
An extra topic here is about another behavior noted in excel module:
it fails to recognize strings containing non-alpha characters, eg, it
imports as "null".
Excel input row examples for column 'code'
row 0: 13416015a
row 1: 13416215
@Column(allowsNull = "true")
@Getter @Setter
@MemberOrder(sequence="1")
private String code;
The imported result is:
row 0: 13416015a
row 1: null
The workaround i learned was set code as int.
Any clue on this issue? Thanks, Eder
