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.
Userlevel 4
+13
- Contributor
- 3725 replies
-
15 January 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.
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....
+22
- Contributor
- 1961 replies
-
15 January 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.
+3
...you can try using python to do that.
from win32com.client import Dispatch
import os
etc.
There are sample codes out on the net.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.