Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Improvements for EXCEL input file

  1. #1

    Default Improvements for EXCEL input file

    Hi everybody,

    With kettle 4.1.1, the management of the sheets by EXCEL input step is not efficient if the names of the sheets are not known at the moment you configure the step.

    It would be fine if the EXCEL input step could allow regexp expressions, variable or parameter in the list of sheets to read instead of an hard coded name.

    It would also be fine if the EXCEL input step could optionally reject a sheet which is not in the list.

    I know that several posts have been written for those kind of improvements but a long time ago (2007, 2008). Any hope for the next version ?

    Regards,
    Gérard

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

    Default

    It all starts either by filing a JIRA request or by voting for an existing case ;-)

  3. #3
    Join Date
    Mar 2008
    Posts
    140

    Default

    Check out this Excel plugin written by Slawomir Chodnicki too. http://type-exit.org/adventures-with...in-for-kettle/

    He might be interested in improvement suggestions as well... not sure.

    But beyond that, as has been said, find or create a Jira.

  4. #4

    Default

    Thank you for your reply.

    The EXCEL writer step seems great but my purpose was to suggest improvement for EXCEL INPUT step.
    The EXCEL writer step plugin is an output step.

    As suggested I have created a JIRA request.

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.