Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Excel Input step aborts with NullPointerException

  1. #1

    Exclamation Excel Input step aborts with NullPointerException

    Hi everybody,

    I am using kettle 4.1.1 and I have to read all the sheets of an EXCEL file with EXCEL input step.

    The step documentation says :
    IMPORTANT: it is also possible to read all sheets in the worksheet.
    To arrive there, simply clear the "List of sheets to read" table and type the start row and column in the first row.
    This will be used for all sheets.
    Again, if you want to read all sheets in the workbook(s), it's important not to specify any sheet name (blank it out)
    But it doesn't work. If I do that I get a "NullPointerException"

    Regards
    Gérard
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    You should file a JIRA.
    I couldn't make it work in 4.1, but in 3.2 it works just like explained in the wiki.

  3. #3

    Default

    Thank you for your reply,

    As suggested I've created a JIRA (http://jira.pentaho.com/browse/PDI-5312)

    Congratulation for Pentaho 3.2 Data Integration: Beginner's Guide
    I started working with kettle by reading this book and doing the exercices

    Gérard

  4. #4
    Join Date
    Sep 2007
    Posts
    834

    Default

    Nice to hear that,
    Merci, Gérard!

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.