Question

Setting colours when writing Excel

  • 8 August 2013
  • 2 replies
  • 15 views

Badge +5
Hi,

 

I'm tryng to do some fancy colour manipulation when using the Excel writer. I'm already using a template XLS to define the basic structure of my output worksheet and that's working fine.

 

 

I'm also defining custom cell (column) formatting on the feature type user attribute definitions, which allows me to specify custom number/date/text format strings and a custom font colour. That's working fine.

 

 

What I would like to do is set a custom background colour for a particular row.

 

 

I know that FME is capable of setting the background colour because if I choose the "Simple" Format Type for the attribute column properties I can specify the font / font color / fill color for a column and it works. However, if I choose the "Custom" Format Type then I have to enter in an Excel compliant format string which onlly offers font colour and not fill colour.

 

 

I've tried setting the fme_fill_color attribute on the desired features but it didn't have any effect.

 

 

Has anyone been able to achieve anything like this?

 

 

I'm using FME 2013 SP3.

 

 

thanks,

 

Nic

 


Reply