Error loading XLSX file from Google Drive because "not a valid OOXML" - Google Drive Plugin

Options
jjc_al
jjc_al Registered Posts: 5 ✭✭✭

Hello,

I am using the Google Drive Plugin (version 1.1.4) with which I'd like to load an .xlsx file from a Google Drive using a service account. However, I get the following error:

"Failed to open Excel file, caused by: NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file, caused by: ZipException: Unexpected record signature: 0XB863D080".

For information, I have checked the XLSX format box in Settings, and the preview displays the table as intended. I have attached screenshots of the error and the Format/Preview settings tab.

Thanks in advance for your help,

Jean-Julien


Operating system used: Linux


Operating system used: Linux

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,740 Neuron
    Options

    Are you sure your file is an actual .xlsx format file and not a .xls file? If it is an actual .xlsx format file you should be able to change the extension to .zip and unzip it's contents.

  • jjc_al
    jjc_al Registered Posts: 5 ✭✭✭
    Options

    Hi Turribeach,

    Thanks for your quick reply. The extension of the file is .xlsx, and when I uncheck the "XLSX format" box, the following error is raised:

    "Tried format excel but configuration is not OK: Failed to open Excel file, caused by: OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)".

Setup Info
    Tags
      Help me…