Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Excel 2007

  1. #1

    Default Excel 2007

    Can you use Excel 2007 files as Input when designing a transformation ?
    I'm using version 4.2 Stable.
    I notiiced when you browse for files that it only looks for Excel 95, 97 or 2000 files.
    I received the following message when I tried to view a 2007 file:
    2011/10/19 17:21:37 - Trans - This transformation can be replayed with replay date: 2011/10/19 17:21:37
    2011/10/19 17:21:37 - Airline.0 - ERROR (version 3.1.0, build 826 from 2009/04/16 13:44:37) : Error processing row from Excel file [C:\Kettle\Baxter\pop\hold\(BAXTER)iJET Airline File-China 13 Oct 2011.xlsx] : jxl.read.biff.BiffException: Unable to recognize OLE stream
    2011/10/19 17:21:37 - Airline.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
    2011/10/19 17:21:37 - Kettle - Transformation detected one or more steps with errors.
    2011/10/19 17:21:37 - Kettle - Transformation is killing the other steps!

  2. #2
    Join Date
    Nov 2009
    Posts
    687

    Default

    Yes you can use Excel 2007. Use the Microsoft Excel input step. Go to the "Content" sheet and select "Excel 2007 XLSX(Apache POI)" Then you can browse for Excel 2007 files and won't get the error you received.

    Greetz,

    Johan

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

    Default

    I've seen the "OLE stream" error as well though. There's something specific in the 2007 format that causes the problem.
    I tried saving the file to xls and then back to xlsx and the issue was gone but I still don't know what exactly it was.

  4. #4

    Default

    I got the following error when I switched to Excel 2007:

    2011/10/20 10:04:22 - Spoon - Logging goes to file:///C:/DOCUME~1/MAERTE~1/LOCALS~...2b0af08171.log
    2011/10/20 10:04:26 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000
    2011/10/20 10:04:30 - Version checker - OK
    2011/10/20 10:10:43 - C:\Kettle\Baxter\_Baxter-airline.ktr : _Baxter-airline - Dispatching started for transformation [C:\Kettle\Baxter\_Baxter-airline.ktr : _Baxter-airline]
    2011/10/20 10:10:43 - Airline.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Error processing row from Excel file [C:\Kettle\Baxter\pop\hold\(BAXTER)iJET Airline File-China 18 Oct 2011.xlsx] : java.lang.NegativeArraySizeException
    2011/10/20 10:10:43 - Airline.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : java.lang.NegativeArraySizeException
    2011/10/20 10:10:43 - Airline.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.excelinput.poi.PoiSheet.getRow(PoiSheet.java:31)
    2011/10/20 10:10:43 - Airline.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:637)
    2011/10/20 10:10:43 - Airline.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:458)
    2011/10/20 10:10:43 - Airline.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/10/20 10:10:43 - Airline.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Unknown Source)
    2011/10/20 10:10:43 - Airline.0 - Finished processing (I=17, O=0, R=0, W=17, U=0, E=1)
    2011/10/20 10:10:43 - C:\Kettle\Baxter\_Baxter-airline.ktr : _Baxter-airline - C:\Kettle\Baxter\_Baxter-airline.ktr : _Baxter-airline
    2011/10/20 10:10:43 - dummy.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
    2011/10/20 10:10:43 - C:\Kettle\Baxter\_Baxter-airline.ktr : _Baxter-airline - C:\Kettle\Baxter\_Baxter-airline.ktr : _Baxter-airline

  5. #5
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    that looks like it may have been fixed already in http://jira.pentaho.com/browse/PDI-6692
    can you check with the latest patch version?

    http://ci.pentaho.com/view/Data%20In...ob/Kettle-4.2/

    Cheers
    Slawo

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.