Adding 2-Color Scale and 3-Color Scale Conditional Formattings

2-Color Scale and 3-Color Scale Conditional Formattings are added in the same way except they are differed by FormatCondition.color_scale.is_3_color_scale property. This property is false for 2-Color Scale and true for 3-Color Scale Conditional Formattings.

The following sample code adds 2-Color and 3-Color Scale Conditional Formattings. It generates the output excel file.

from aspose.cells import CellArea, FormatConditionType, Workbook
from aspose.pydrawing import Color

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook
workbook = Workbook()
#  Access first worksheet
worksheet = workbook.worksheets[0]
#  Add some data in cells
worksheet.cells.get("A1").put_value("2-Color Scale")
worksheet.cells.get("D1").put_value("3-Color Scale")
for i in range(2, 15 + 1):
    worksheet.cells.get("A"  + str(i)).put_value(i)
    worksheet.cells.get("D"  + str(i)).put_value(i)
#  Adding 2-Color Scale Conditional Formatting
ca = CellArea.create_cell_area("A2", "A15")
idx = worksheet.conditional_formattings.add()
fcc = worksheet.conditional_formattings[idx]
fcc.add_condition(FormatConditionType.COLOR_SCALE)
fcc.add_area(ca)
fc = worksheet.conditional_formattings[idx][0]
fc.color_scale.is_3_color_scale = False
fc.color_scale.max_color = Color.light_blue
fc.color_scale.min_color = Color.light_green
#  Adding 3-Color Scale Conditional Formatting
ca = CellArea.create_cell_area("D2", "D15")
idx = worksheet.conditional_formattings.add()
fcc = worksheet.conditional_formattings[idx]
fcc.add_condition(FormatConditionType.COLOR_SCALE)
fcc.add_area(ca)
fc = worksheet.conditional_formattings[idx][0]
fc.color_scale.is_3_color_scale = True
fc.color_scale.max_color = Color.light_blue
fc.color_scale.mid_color = Color.yellow
fc.color_scale.min_color = Color.light_green
#  Save the workbook
workbook.save(dataDir + "output_out.xlsx")