Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Excel Rows Problem

  1. #1
    Join Date
    Jul 2010
    Posts
    6

    Default Excel Rows Problem

    Hi,
    I am using Pentaho 1.7 version ,when i download any report in Excel format and If data is moe than 65000 rows ,it throws an exception.
    How to come up with this issue ,kindly help .

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

    Default

    This is a limit in the Excel .xls file format, which is apparently relieved in the .xlsx format, but 1.7 cannot write .xlsx files...

    I'm not sure if there is a version that does at this point.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  3. #3
    Join Date
    Jul 2010
    Posts
    6

    Default

    Thanks for ur response , Is there no solution for this issue ?????,

  4. #4
    Join Date
    Jul 2009
    Posts
    475

    Default Is CSV output an option?

    I'm not familiar with Pentaho 1.7, but if you can use CSV as an output format, then maybe you could output to CSV and open that with Excel.

  5. #5
    Join Date
    Jul 2010
    Posts
    6

    Default

    hi,

    Shall I upgrade my pentaho version from 1.7 to 1.8 . ???
    Is this will resolve this issue ???

  6. #6

    Default

    As far as I know, this issue is not addressed in any Pentaho version, since it doesn't support xlsx files.

    http://jira.pentaho.com/browse/PRE-496

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.