Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Excel Input: No Get fields from Header row

  1. #1
    Join Date
    Aug 2008
    Posts
    11

    Unhappy Excel Input: No Get fields from Header row

    I have a excel file with multiple sheets.
    Option "Get sheetnames" work fine. I selected sheet "Mayo 08", Start Row = 4, Start Column = 1
    In the tab Content, "Header" check is marked.
    In the tab Fields, option "Get fields from header row..." doesn't work.
    Give me the error: I was unable to find any fields in the excel file(s)

    And the option "Previews rows" give these errors:

    org.pentaho.di.core.exception.KettleException:
    We failed to initialize at least one step. Execution can not begin!
    at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:580)
    at org.pentaho.di.ui.trans.dialog.TransPreviewProgressDialog.doPreview(TransPreviewProgressDialog.java:139)
    at org.pentaho.di.ui.trans.dialog.TransPreviewProgressDialog.access$000(TransPreviewProgressDialog.java:47)
    at org.pentaho.di.ui.trans.dialog.TransPreviewProgressDialog$1.run(TransPreviewProgressDialog.java:78)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

    Waht is wrong?

    Kettle - Spoon version 3.0.4
    Windows XP Pro

    Thanks
    Monica

  2. #2

    Default

    Hi Monica,
    which Excel version did you choose when saving the file?
    I ask because the 3rd party library used to read Excel files does not support latest Excel versions.

    Christoph
    21 is only half the truth

  3. #3
    Join Date
    Aug 2008
    Posts
    11

    Wink

    Hi,
    I use Excel 2003.
    But, just testing with older versios, I saw de error:
    Spoon counts rows starting in 0, not 1.
    That was my problem.

    Thanks,

    Monica

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.