Skip to main content
Question

I'm using the excelstyler writing to excel feature writer. Its applying the formatting (highlight full row) except to some date cells it only applies it to those cells in first row rather than those in every row that meets the condition.

  • August 25, 2021
  • 2 replies
  • 17 views

Forum|alt.badge.img
I'm using the excelstyler writing to excel feature writer. Its applying the formatting (highlight full row) except to some date cells it only applies it to those cells in first row rather than those in every row that meets the condition.

2 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • September 4, 2021

Hi @jwcc​ 

 

Could you share the Workspace that you are working?

 

Thanks in Advance,

Danilo


Forum|alt.badge.img
  • Author
  • 3 replies
  • September 6, 2021

Hi @jwcc​ 

 

Could you share the Workspace that you are working?

 

Thanks in Advance,

Danilo

Hi,

I have actually resolved issue. I applied two excelstyler transformers

 

Eg

first one applied to complete row to set back color to blue based on condition

second one applied to a cell based on a condition to set font red but also set back color for that cell to blue as the second styler overwrites the style applied by first excelstyler

 

Thanks for response.