生成条件格式数据条形图像

有时，您需要生成条件格式化 DataBars 的图片。可以使用 Aspose.Cells DataBar.to_image() 方法生成这些图片。本文展示了如何使用 Aspose.Cells for Python via .NET 生成 DataBar 图片。

以下示例代码生成了单元格 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)