Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Excel Writer step and cells background color

  1. #1
    Join Date
    Jan 2006
    Posts
    245

    Default Excel Writer step and cells background color

    Hi everybody,

    I'm using the Excel Writer step to fill an Excel template file. The cells in my template has a yellow background but as soon as the steps fills that cells the background color is lost and they get a white background. In the step configuration I set the "Leave style of existing cells unchanged" to true but it seems it doesn't work.... or am I missing something?

    Is there anyone that can explain me what I am missing?

    Kind regards

    Sergio
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  2. #2
    Join Date
    Jun 2011
    Posts
    102

    Default

    Hi man,
    when i want to set a bg color to a column i set a cell (like AB1) with that colour, then in the content page of the Excel writer, under "style from cell", i type where to pick the style (ex. AB1).
    This work for me, HTH.
    See ya,
    Lom.

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.