Color the Columns/Cells of an Output Excel File

Situation:

The output excel file should have colors in certain columns or based on certain values in particular cells. For example, user wants to create an excel report with the different color scheme for certain columns. Like, we have a Status column in our excel file and if it has a value "Fail' then the text color should be red or the cell color should be in red.

Solution:

You can achieve this requirement by using the below-attached custom plugin after the source file activity in the process flow. For an example, you can refer the below screenshot.

unnamed.png

After the flow's execution, the source file activity will have cell marked as RED in color for every cell containing the keyword "fail".

Colored_Cell.png

NotePlease make sure before executing the flow we need to specify the column number (at line 58 in the custom plugin script) where "Status" column exists.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.