Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Issue with Excel output step in Pentaho 6 for xlsx output format

  1. #1
    Join Date
    Jul 2012
    Posts
    13

    Default Issue with Excel output step in Pentaho 6 for xlsx output format

    Hi,

    I am trying to generate xlsx output from excel output step in Pentaho 6 version. Transformation running successfully but its throwing an error when we are trying to open file.
    Using same excel output step we are able to generate xls file without any formatting issue.

    Error:
    Excel cannot open file because file format or file extension is not valid.Verify file has not been corrupted and that file extension matches the format of the file.
    PFA of error.

    Kindly help us with this issue.
    Attached Images Attached Images  

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Microsoft-Excel-Output is BIFF8 only.
    For XLSX use Microsoft-Excel-Writer.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Jul 2012
    Posts
    13

    Default

    Thank you will use excel writer step.

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.