Export to Excel. Dynamic color and setting of each cell based on attribute

0
Hello. I am working on export-to-excel function at the moment and have some issues. I need to change a specific cell color (Ex. A1) based on boolean value or integer value. I will attach an example image below and would love t know if it is possible and if possible could you please teach me how I can achieve this? Thank you in advance!  
asked
2 answers
0

Hello ;) 

 

I don't think it's possible to do this via the tradiational excel exporter module from Mendix 

 

I would rather try using the Advanced Excel marketplace module 

 

https://marketplace.mendix.com/link/component/116370

answered
0

Hey Jay,

Excel Exporter module does not provide a lot of customization options. 

During the template creation you can go to

imagem.pngimagem.png

 

 

Other option is the module Marcian mention in the other answer (Advanced Excel)

Note: Advanced Excel is community support

 https://marketplace.mendix.com/link/component/116370

 

 

This module offers a whole new level of customization. You can specify the style for each cell in the microflow.

Documentation for this module is sparse, but you can check out this video on YouTube:

https://www.youtube.com/watch?v=HxWTs94vhTo

 

If this answer helped you, mark as accepted

 

Best Regards,

Ricardo Pereira

answered