Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problem MS Excel Input, specific location of data in sheet, get fields gives error

  1. #1
    Join Date
    Apr 2014
    Posts
    7

    Default Problem MS Excel Input, specific location of data in sheet, get fields gives error

    Hi,

    I am trying to get data in from an Excel sheet.
    start of the location is at colum B cel 21. I can't get fields from header Row, also "faking" it, doesn't solve it because when you hit "Preview Rows" it gives an error.

    2014/05/06 22:37:23 - Spoon - Asking for repository
    2014/05/06 22:37:23 - RepositoriesMeta - Reading repositories XML file: H:\.kettle\repositories.xml
    2014/05/06 22:37:23 - Version checker - OK
    2014/05/06 23:16:24 - /Transformation 1 - Dispatching started for transformation [/Transformation 1]
    2014/05/06 23:16:25 - /Transformation 1 - /Transformation 1
    2014/05/06 23:16:25 - /Transformation 1 - /Transformation 1

    I am running this on Windows 7 (32bit). (local install)

    I've tried a lot of potential column (A , B, C, D) and also a lot of different Row numbers... no result at all.
    The strange thing is when the data is in cell A1, and i specify that it starts at column B2... It still start at A2...

    COuld somebody tell me what I'am doing wrong...
    excelproblemloadingSheet2.zip

    i've attached the excel sheet which gives the error...

  2. #2
    Join Date
    Apr 2014
    Posts
    7

    Default

    I've found it..
    Do not use the Letter code of the column but you need to count the columns..

    Thanks any way for reading..
    Anton

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.