Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PDI 8.2.0.0-342 Microsoft Excel input step - Browse doesn't "see" xlsx files

  1. #1
    Join Date
    Jun 2015
    Posts
    6

    Default PDI 8.2.0.0-342 Microsoft Excel input step - Browse doesn't "see" xlsx files

    I've been using PDI for quite some time but this is the first time I've run across this issue. I'm trying to load an Excel (xlsx) file into the Microsoft Excel input step. Yet when I browse to the folder containing my xlsx files nothing shows up in the step's browse window. It will see xls files but not xlsx files. If I change the browse filter to "all files" to where I can see the xlsx files, add one, and then try to get the sheet names I get the following error:

    org.pentaho.di.core.exception.KettleException:
    jxl.read.biff.BiffException: Unable to recognize OLE stream
    Unable to recognize OLE stream


    at org.pentaho.di.trans.steps.excelinput.jxl.XLSWorkbook.<init>(XLSWorkbook.java:54)
    at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:39)
    at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.getSheets(ExcelInputDialog.java:1922)
    at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog$17.widgetSelected(ExcelInputDialog.java:1184)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.open(ExcelInputDialog.java:1214)
    at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:120)
    at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8662)
    at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3293)
    at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:785)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1381)
    at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7817)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9179)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:707)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
    Caused by: jxl.read.biff.BiffException: Unable to recognize OLE stream
    at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
    at jxl.read.biff.File.<init>(File.java:127)
    at jxl.Workbook.getWorkbook(Workbook.java:268)
    at org.pentaho.di.trans.steps.excelinput.jxl.XLSWorkbook.<init>(XLSWorkbook.java:52)
    ... 29 more

    I have Office 2016 installed on my computer.

    Thanks.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Remember to change your spreadsheet type before you try to find the files (don't worry... I make this mistake *ALL* the time)
    If you change it from "Excel 97 - 2003 XLS (JXL)" to "Excel 2007 XLSX (Apache POI)", the file browser changes to XLSX, and the sheets button will work correctly.

  3. #3
    Join Date
    Jun 2015
    Posts
    6

    Default

    Quote Originally Posted by gutlez View Post
    Remember to change your spreadsheet type before you try to find the files (don't worry... I make this mistake *ALL* the time)
    If you change it from "Excel 97 - 2003 XLS (JXL)" to "Excel 2007 XLSX (Apache POI)", the file browser changes to XLSX, and the sheets button will work correctly.
    I'm an idiot... that was it. Thanks for breaking it to me so nicely!! I appreciate it!

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.