Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Excel Input - Sheet Id instead of sheet Name

  1. #1

    Smile Excel Input - Sheet Id instead of sheet Name

    Hi guys,

    I usually load an excel file to a database. I configure the excel input and load the data directly to the DB. The issue here is that the sheet name may vary over time, so, I have to reconfigure the sheet name in the step to make it work properly.

    My question: Is there a way to define in the excel input step, instead of the sheet name, the sheet id or number?

    Using this way, it wouldn't matter what is the sheet name, it will always load, for example sheet 1.

    Any Advice,

    Regards,

    Ben

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

    Default

    Not right now.

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.