Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: PDI Excel Output

  1. #1
    Join Date
    Jan 2006
    Posts
    153

    Default PDI Excel Output

    I have a request to generate an Excel file with 130,000 rows. Can PDI generate output in xlsx format, so I can put that many rows in the file? If so, how?

    Thanks

  2. #2
    Join Date
    Jan 2006
    Posts
    153

    Default

    I am using PDI 4.0.0 on Pentaho 3.6.0 on a JBoss-eap-5.0.1 server. I also realized I need to ask the same question about Excel Input. Can PDI handle xlsx input?

  3. #3
    Join Date
    Mar 2010
    Posts
    159

    Default

    Search for slawo's plugin to handle .xlsx

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    In version 4.1.x there is support for reading XLSX and OpenOffice in the "Excel Input" step.
    Last edited by MattCasters; 02-16-2011 at 05:27 PM.

  5. #5
    Join Date
    Jan 2007
    Posts
    485

    Default Excel Input Step: xlsx files too

    Quote Originally Posted by MattCasters View Post
    In version 4.1.x there is support for reading XLSX and OpenOffice in the "Excel Input" step.
    Great news Matt... the step works like a charm.... Kind regards.

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.