条件付き書式のデータバー画像を生成

Contents
[ ]

次のサンプルコードは、セルC1のDataBar画像を生成します。まず、セルの書式条件オブジェクトにアクセスし、そのオブジェクトから、DataBarオブジェクトにアクセスして、そのto_image()メソッドを使用してセルの画像を生成します。最後に、画像をディスクに保存します。

from aspose.cells import CellArea, FormatConditionType, Workbook
from aspose.cells.drawing import ImageType
from aspose.cells.rendering import ImageOrPrintOptions
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# Source directory
sourceDir = RunExamples.Get_SourceDirectory()
# Output directory
outputDir = RunExamples.Get_OutputDirectory()
# Create workbook object from source excel file
workbook = Workbook(sourceDir + "sampleGenerateDatabarImage.xlsx")
# Access first worksheet
worksheet = workbook.worksheets[0]
# Access the cell which contains conditional formatting databar
cell = worksheet.cells.get("C1")
# Create and get the conditional formatting of the worksheet
idx = worksheet.conditional_formattings.add()
fcc = worksheet.conditional_formattings[idx]
fcc.add_condition(FormatConditionType.DATA_BAR)
fcc.add_area(CellArea.create_cell_area("C1", "C4"))
# Access the conditional formatting databar
dbar = fcc[0].data_bar
# Create image or print options
opts = ImageOrPrintOptions()
opts.image_type = ImageType.PNG
# Get the image bytes of the databar
imgBytes = dbar.to_image(cell, opts)
# Write image bytes on the disk
with open(outputDir + "outputGenerateDatabarImage.png", "wb") as f:
f.write(imgBytes)
view raw Cells-Formatting-GenerateDatabarImage-1.py hosted with ❤ by GitHub
条件付き書式を使用して交互の行と列に網掛けを適用する Python.NETを使った高度な条件付き書式の適用