Skip to main content
Solved

HOW to assign RED Colour to CELL in Excel File ?


vimva679
Supporter
Forum|alt.badge.img+9

How to assign RED colour to this cell in final output of EXCEL file.

 

Because TESTFILTER have filtered this Column, whatever Rows are there, irrespective value inside the cell i would like to assign RED colour to the CELL marked with a Blue circle inside final excel file, 

 

 

 

 

this is default OUTPUT 

 

This is how I WANT

 

Best answer by jkr_wrk

I think your answer is here:

The same way you test on the color, when reading, you use that attribute to write the color when writing.

On this page there is a paragraph formatting:

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm

View original
Did this help you find an answer to your question?

2 replies

jkr_wrk
Influencer
Forum|alt.badge.img+29
  • Best Answer
  • June 2, 2024

I think your answer is here:

The same way you test on the color, when reading, you use that attribute to write the color when writing.

On this page there is a paragraph formatting:

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm


vimva679
Supporter
Forum|alt.badge.img+9
  • Author
  • Supporter
  • June 7, 2024

It works perfectly now please find the solution to write the colour in cell of excel file

 


Reply


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