Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Appending to different sheets in Excel Output...

  1. #1
    Join Date
    Oct 2008
    Posts
    17

    Default Appending to different sheets in Excel Output...

    Hi,

    Is there anyway for a single transformation to add a worksheet to an existing excel document without overwritting the ones that are already present in the excel file? e.g. Iv got a transformation that outputs to an excel file with a sheetname named by environmental variables (${EXCHANGE}_${MONTH}_${CURRENCY}), but everytime I run it with new variables it doesnt keep the sheets in the excel file that were created in a previous transformation.

    Any ideas?

    Thanks
    Tim

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    No ... or no, not yet... but I doubt the library we use to write excel files supports it.

    Regards,
    Sven

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.