2色系規則と3色系規則の条件付き書式設定を追加する

2色スケールおよび3色スケール条件付き書式の追加は、FormatCondition.color_scale.is_3_color_scaleプロパティによって異なります。このプロパティは、2色スケールの場合はfalse、3色スケールの場合はtrueです。

次のサンプルコードは、2色スケールと3色スケール条件付き書式を追加し、出力されたExcelファイルを生成します。

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")