Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Fill excel with data in specific cells

  1. #1

    Default Fill excel with data in specific cells

    Hi all,

    I have a data stream with just one row and 4 fields.
    I want to put each of the 4 fields in especific cells of an excel template using the Excel Writer step. That is for the row I have I want pentaho kettle to create an excel file with one sheet and in that sheet to have field_1 in cell C4, field_2 in cell D7, field_3 in cell E1 and field_4 in cell E1.

    Can anyone help me in how to approach this?

    Thanks in advance.

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

    Default

    Of course, it can be done, but it's definitely not the best use case for Kettle - you don't use heavy machinery to plant a single onion.
    Attached Files Attached Files
    So long, and thanks for all the fish.

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.