[DRILL-8071] format-excel data parsing should use POI code

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.20.0
• Component/s: Execution - Data Types
• Assignee: Unassigned
• Reporter: PJ Fanning
• Created: 07/Dec/21 11:06
• Updated: 29/May/22 07:07
• Resolved: 29/May/22 07:07

Description

There is also custom code for handling the conversion of the raw numbers representing dates/timestamps but this also seems like a bad idea. The Cell class has getLocalDateTimeCellValue and this has the right logic for converting 1904 and 1900 based dates - yes, Excel uses 2 different formats.

Code that processes excel files is a real pain to get right because the Microsoft storage format is really bad.