Variable background color of a cell using the excel exporter

2
Hi there, I have constructed a microflow that generates an excel template using the excel exporter module. Now I want to add some conditional styling on one of my colums. I want to change the background color of a cell based on the attributes value.  Does anyone know if this is possible and how to do this?  Thanks for your help! Kind regards, Tim Vredevoort  
asked
1 answers
1

You're creating the template here, which does not have access to the values in a cell.

To my knowledge, the Excel exporter does not support conditional formatting based on the value of a cell. You'd need to implement this in Java yourself. Based on a quick search, I think you'd use methods from this class:

https://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFConditionalFormatting.html

answered