Hi Team,
I want to add conditional formatting (icon set rules to be added)to excel sheets in Outsystems while exporting records to excel. Based on the value , icon needs to be changed like red ,green , yellow. Can anyone help me on this, how to achieve the same like below added screenshot. I have tried advanced excel component, still I can't get the desired Output.
Thanks in Advance.
Hi Shyam
It is not currently possible, but it seems it is supported by the EPPlus library and needs to be added to the extension.
Hanno
Hi Hanno,
Thanks for your suggestion. It will help me.
Hi Shyam,
This is supported now — make sure you grab the latest version of Advanced Excel from the Forge, then use the ConditionalFormatting_AddRule action. It supports 3/4/5 icon sets (traffic lights, arrows, flags, etc.), which is exactly the red/yellow/green look in your screenshot.
Build a ConditionalFormatItem like this and pass it to ConditionalFormatting_AddRule:
Important — icon sets evaluate numeric values, not text. Excel splits the numbers into thresholds (default: bottom third → red, middle → yellow, top → green). So the cells in that range need to hold numbers, not "YES"/"NO". For a status column, write a number (e.g. 0 = bad/red, 1 = ok/yellow, 2 = good/green) and let the icon set color it — with ShowValue = False the user only sees the circle.
So the flow is: write your numeric status values → build the ConditionalFormatItem above → call ConditionalFormatting_AddRule(Worksheet, ConditionalFormatItem) → Workbook_GetBinaryData to download.
If your source data is YES/NO, just map it to 1/0 when writing the cells and you'll get the green/red icons. Hope this helps!