Close popover
Jason Lavigne (Jason.Lavigne)
Frontier BPM, Inc.
Frontier BPM, Inc.
Jason.Lavigne Member since 2015 2 posts
Frontier BPM, Inc.
Posted: September 27, 2019
Last activity: September 27, 2019

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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.