Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Problem around Excel version

  1. #1
    Join Date
    Nov 2007
    Posts
    22

    Default Problem around Excel version

    Hi,

    I'm trying to manipulate some excel files.

    When the excel is created using 2003 version of Excel we can't load them. But when is created with a previous Excel version, everything is ok

    We have noticed that when you use an Excel as input and you use the spoon browser there is a buttom, "Excel 95, 98, 2000" or "all files"

    Is there something special around Excel 2003?

    Will we be able to load 2003 excel files?

    Thanks in advance for your help.

    Regards,

    Ana.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    I never had any problems myself, but the open source library we use (jxl) only explicitly supports versions lower than 2003.

    Matt

  3. #3
    Join Date
    Nov 2007
    Posts
    22

    Default

    We think that spoon can´t load Excel files when the file contains Excel "Auto filters" in the columns...

    Regards,

    Ana.

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.