Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Excel input Step- Spread type engine

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Excel input Step- Spread sheet type engine

    Hi All,

    I have 3 excel files with same format. I am doing some transformations on it. I execute it in loop.
    I have selected Spread sheet Type engine as "Excel 2007 Apache POI streaming" in excel input step. It works fine for 2 excel files. But for 1 excel file it does not return any rows.
    For that 1 excel file it works with "Excel 2007 Apache POI" Spread sheet Type engine. why so?
    What is the diffrence between "Excel 2007 Apache POI streaming" and "Excel 2007 Apache POI" Spread sheet Type engines?
    I noticed "Excel 2007 Apache POI streaming" works faster.
    So How can I make Spread sheet Type engine as "Excel 2007 Apache POI streaming" work for all 3 excels?
    I use penhato 7.1. Windows 7. JRE 1.8

    please help
    Thanks
    Last edited by Ajinkya; 08-23-2018 at 07:57 AM.

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.