生成条件格式 DataBars 图像
Contents
[
Hide
]
有时,您需要生成条件格式数据条的图像。您可以使用 Aspose.Cells数据条.ToImage()生成这些图像的方法。本文介绍如何使用 Aspose.Cells 生成 DataBar 图像。
以下示例代码生成单元格 C1 的 DataBar 图像。首先,它访问单元格的格式条件对象,然后从该对象访问数据条对象并使用其印象()生成细胞图像的方法。最后,它将图像保存在磁盘上。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
//Source directory | |
string sourceDir = RunExamples.Get_SourceDirectory(); | |
//Output directory | |
string outputDir = RunExamples.Get_OutputDirectory(); | |
// Create workbook object from source excel file | |
Workbook workbook = new Workbook(sourceDir + "sampleGenerateDatabarImage.xlsx"); | |
// Access first worksheet | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Access the cell which contains conditional formatting databar | |
Cell cell = worksheet.Cells["C1"]; | |
// Create and get the conditional formatting of the worksheet | |
int idx = worksheet.ConditionalFormattings.Add(); | |
FormatConditionCollection fcc = worksheet.ConditionalFormattings[idx]; | |
fcc.AddCondition(FormatConditionType.DataBar); | |
fcc.AddArea(CellArea.CreateCellArea("C1", "C4")); | |
// Access the conditional formatting databar | |
DataBar dbar = fcc[0].DataBar; | |
// Create image or print options | |
ImageOrPrintOptions opts = new ImageOrPrintOptions(); | |
opts.ImageType = Drawing.ImageType.Png; | |
// Get the image bytes of the databar | |
byte[] imgBytes = dbar.ToImage(cell, opts); | |
// Write image bytes on the disk | |
File.WriteAllBytes(outputDir + "outputGenerateDatabarImage.png", imgBytes); |