Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: excel input having merged rows

  1. #1

    Default excel input having merged rows

    Hi,

    How can I parse an excel input having merged cells??? Attaching the sample excel file. I need to process the data from row 22 to 172, and need the columns "parameters","G" and "W", and the values will be updated in a table. Any suggestion???

    Thanks.
    Poulomi
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    With merged cells the rows and columns are still the same, it's just a presentation thing you can ignore.
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3

    Default

    Quote Originally Posted by marabu View Post
    With merged cells the rows and columns are still the same, it's just a presentation thing you can ignore.
    Thank you

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.