Skip to main content
Question

setting excel row colour

  • January 14, 2015
  • 4 replies
  • 57 views

jdh
Contributor
Forum|alt.badge.img+28
  • Contributor
Hi all,

 

 

Is there a way to set the colour (background or text) of a row in excel based on an attribute value?

 

 

I would like to be able to highlight certains rows in the file based on whether they passed or failed validation.

4 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • January 15, 2015
Hi,

 

I dont think there is a way to it via an attribute value.  You could alternatively use different writer feature types that will result in different tabs.

  • January 15, 2015
Hi,

 

I can't think of a way to do this in FME but in Excel you can colour cells or entire rows based on a condition. Navigate in Excel to the Home tab, Styles group, and choose Conditional Formatting > New Rule....

jdh
Contributor
Forum|alt.badge.img+28
  • Author
  • Contributor
  • January 15, 2015
Unfortunately I'm already using different tabs for other reasons.  I was hoping to avoid having to make any changes in the excel file post process.

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • January 15, 2015
...you can try using python to do that.

 

 

 

 

from win32com.client import Dispatch

 

import os

 

 

etc.

 

 

There are sample codes out on the net.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings