Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Different Excel worksheet names

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Different Excel worksheet names

    Hello everyone!

    I have bunch of excel files that I would like to process with PDI. They all have the same format, but each each file contain only one worksheet and worksheet's names differ from one file to another. Is there way to process them all at once?

    Regards,
    Alex

  2. #2
    Join Date
    Sep 2011
    Posts
    171

    Default

    Is it possible to use variable in "Sheet name" field?
    Last edited by august_month; 11-18-2011 at 01:39 PM.

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Just leave the sheet names blank and they will all be read.

  4. #4
    Join Date
    Sep 2011
    Posts
    171

    Default

    Super! It worked!

  5. #5
    Join Date
    Mar 2011
    Posts
    4

    Default doesn't work when I need to start at a certain row/column

    Hi,

    I have this issue too, but most of my Excel files have to be read starting at a specific row/column so I have to load the sheet name - correct?

    Is there any way to load a different sheet name with each run?

    Thanks,

    Robin

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.