Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: jxl.read.biff.BiffException: Unable to recognize OLE stream

  1. #1
    Join Date
    Apr 2014
    Posts
    4

    Default jxl.read.biff.BiffException: Unable to recognize OLE stream

    Hi,

    I have implemented a program in JAVA to execute kettle transformations.

    I have a kettle transformation which is responsible for loading XLS file into a database table. I am able to load XLS file data successfully.

    Now I have modified the kettle transformation to take XLSX file and tried to load, but I am getting the following ERROR when I execute the transformation using JAVA program:


    ERROR 23-04 13:24:52,065 - SAP DATA.0 - Error processing row from Excel file [C:\Files\SAP_Data_File.xlsx] :
    jxl.read.biff.BiffException: Unable to recognize OLE stream

    Can anyone help me how to resolve this issue.?

    Thanks & Regards,
    Samanth

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    You can't use the XLS importer to read XLSX files. You need to tell your transform to use the XLSX importer (POI)

    The files types are completely different.

  3. #3
    Join Date
    Apr 2014
    Posts
    4

    Default

    I have modified my kettle transformer to content type as POI and I am able to using kettle spoon.

    But I am not able to run using java, though I added all the required POI jars.
    I am getting the same error.

    Thanks,
    Samanth

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    The error message indicates that you're trying to import an XLSX file with the XLS importer.
    Using Java, you may not be using things as they are configured in the KTR, but may be overriding them in java code.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.