Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Null Pointer Exception for Excel Input Step

  1. #1
    Join Date
    May 2011
    Posts
    24

    Default Null Pointer Exception for Excel Input Step

    Hello,

    I get a Null pointer exception for the Excel input step when I am using an excel file of 2007 format and has one of cells in the first column empty. For this i use the Apache POI format in the content tab of the step. But when I change it to a step that reads only 1997-2003 excel files using the JXL sheet type in the content tab, it works fine. Can anyone please guide me one where I am going wrong with the 2007 type excel files. I am using version 4.1.0


    Thanks

  2. #2
    Join Date
    Jan 2006
    Posts
    245

    Default

    POI has some problems in managing the new excel files format. Better if you convert them to the old .xls format and use it that way or you can have a big headache (I had....).

    S
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

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.