Question

4
Replies
44
Views
Jason.Lavigne Member since 2015 1 post
Frontier BPM, Inc.
Posted: September 27, 2019
Last activity: September 27, 2019
Closed

ExcelReader - capturing invalid date formats

We are using the ExcelReader jar (from insurance) to intake an excel file. We've defined some columns as "Date" fields (in the hashmap passed to the readExcel method). It looks like if the date isn't a valid format (in excel), the value is getting returned as blank. We need to capture that condition as an error (some of these date columns are not required and will therefore not get caught by any validate rules).

couple of questions:

1) is there any documentation on the ExcelReader class (methods, etc.)?

2) someone had pointed us at the getErrorList() method, but it's not capturing the invalid date (or we can't interpret the ArrayList. Is there another way to capture these format errors?

3) is there any way to get the "raw" value from the cell? we could then check if it's truly a blank or just an invalid format

Low-Code App Development
Moderation Team has archived post
Share this page LinkedIn