Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Excel output and multiple tabs

  1. #1
    Join Date
    May 2010
    Posts
    8

    Default Excel output and multiple tabs

    Hello,

    I would like to use the Excel Output transformation step, and have it write to a tab (in an existing spreadsheet containing multiple tabs). And then either hide that tab or switch to another tab before saving. Anyone know if this is possible in PDI? Using version 4.1 community edition.

    The reason is that my analysts have created a spreadsheet formatted how they want, and they'd like me to just populate the data and have their other tabs recalculate off of that tab. Then I'd use PDI to email out to the end users, and when they open up the spreadsheet, they want them to see those formatted tabs instead of the data tab.

    So far, I can only get PDI to write to the first tab, and have no idea how to hide or switch tabs prior to saving.

    Thanks - any help would be appreciated!

    Nick

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

    Default

    I've used 4.1 with the default Excel writer to write to multiple tabs... Just one tab at a time.

    Slawo's Excel output does a really good job of working with templates. Check it, and try it out.
    **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
    May 2010
    Posts
    8

    Default

    Thanks! - that pluggin did the trick

Tags for this Thread

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.