Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Excel input and Sheet name

  1. #1

    Default Excel input and Sheet name

    Greetings.

    I have created a simple transformation which processes MS Excel files and loads them into a MySQL db table. Nothing fancy.

    Today, our hardware supplier changed how they create&populate the MS Excel files they send us. Instead of using the default sheet name in MS Excel to "Sheet1", they now use the number of the container they ship to us.

    Obviously, my transformation will fail. "Sheet1" will not exist in the Excel input step.

    Is there a way to "read" off of my inbound Excel file the name of the sheet?

    I am using PDI 4.1.0 on a MS Windows 2003 Server.

    Thanks for your input.
    Pentaho Data Integration CE 5.3.0.x
    JDK 1.7
    OS X Yosemite version 10.10.x
    MySQL 5.5.37
    Amazon Redshift
    Pacific Standard Time

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Uhmm... a similar conversation seems just to have concluded:
    http://forums.pentaho.com/showthread...etname-Problem

    Cheers

    Slawo

  3. #3

    Default

    Cool. I took out the sheet name, per Matt's recommendation. It works.

    Thank you, Slawo.
    Pentaho Data Integration CE 5.3.0.x
    JDK 1.7
    OS X Yosemite version 10.10.x
    MySQL 5.5.37
    Amazon Redshift
    Pacific Standard Time

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.