You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2022/01/03 09:29:00 UTC

[jira] [Commented] (DRILL-8071) format-excel data parsing should use POI code

    [ https://issues.apache.org/jira/browse/DRILL-8071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17467869#comment-17467869 ] 

ASF GitHub Bot commented on DRILL-8071:
---------------------------------------

luocooong commented on pull request #2417:
URL: https://github.com/apache/drill/pull/2417#issuecomment-1003965555


   Before that, there was an issue that the Travis CI was frozen :
   ```
   We are unable to start your build at this time.
   You exceeded the number of users allowed for your plan. Please review your plan details and follow the steps to resolution.
   ```
   I have contacted their tech support today and they seem to have solved the issue for us.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> format-excel data parsing should use POI code
> ---------------------------------------------
>
>                 Key: DRILL-8071
>                 URL: https://issues.apache.org/jira/browse/DRILL-8071
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Execution - Data Types
>    Affects Versions: 1.19.0
>            Reporter: PJ Fanning
>            Priority: Major
>
> 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.
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)