[DRILL-8417] Allow Excel Reader to Ignore Formula Errors

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.21.0
• Fix Version/s: 1.21.1
• Component/s: Storage - Excel
• Assignee: Charles Givre
• Reporter: Charles Givre
• Created: 30/Mar/23 13:27
• Updated: 19/Apr/23 08:39
• Resolved: 19/Apr/23 08:39

Description

If Drill encounters an Excel formula which is invalid somehow, such as a DIV/0, Drill is unable to proceed and throws a number format exception. 

This PR adds a config parameter called ignoreErrors which allows Drill to skip such records and returns null for that cell.  Drill will also output a log warning.  When set to false, original behavior is retained.