Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Kettle 6.1 and XLSX File

  1. #1
    Join Date
    Aug 2017
    Posts
    2

    Default Kettle 6.1 and XLSX File

    Hi to all guys,
    i need your help to understand a strange situation.
    I need to import some data from an xlsx file that containt 16 sheet.

    Actually the xlsx file has a dimension of 20MB.

    If i try to import it as Apache POI Kettle crash... i've already tried to increase JVM options in spoon.bat but i don't have a large amount of memory in the server.

    For this reason io try to import the file using Apache POI Streaming and it works like a charm.

    For the previous operation i was using a test file.

    When my import job was ready, i receive the real file, and the job runs correctly without importing a single row.

    I've see that the only difference between the test file and the real file is this:
    Test file: program name: microsoft excel
    Real file: program name: apache poi


    so it seems that id the xlsx file is created with Apache POI kettle is not able to read its content.

    Any ideas?

    Thanks in advance

  2. #2
    Join Date
    Aug 2017
    Posts
    2

    Default

    Hi guys,
    someone has some ideas to solve this problem? Was it clear?

    Thanks,
    Marco

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 - 2017 Pentaho Corporation. All Rights Reserved.