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.
Hi all,
Page 1 / 1
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.
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....
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.
...you can try using python to do that.
from win32com.client import Dispatch
import os
etc.
There are sample codes out on the net.