Frontier BPM, Inc.
Last activity: 27 Sep 2019 17:01 EDT
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