Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Extraction from Excel

  1. #1
    Join Date
    Feb 2011

    Default Extraction from Excel


    In Pentaho Data Integration, I want to do an extraction from an excel file, but it does not work, the problem is that each field is in a box , I tried to convert the file in csv format in order to have fields between ""and separated by; (because it works for a csv file with fields that are between ""and separated by but the fields remain in boxes in the converted csv file.

    I prefer a solution where I did not need to convert to csv (direct extraction from the excel file), but I'm interested in any solution.

    And thank you in advance.

  2. #2
    Join Date
    Dec 2009



    what´s wrong about the "Excel Input Step" and configuring the "Sheet" and "Field" Tabs correctly?

    Best regards,


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.