获取在条件格式中使用的图标集、数据条或颜色刻度对象

有时，您需要检索用于单元格或单元格范围条件格式的图标集，并需根据此创建图像文件。您可能需要读取在条件格式中使用的数据条或颜色刻度。Aspose.Cells 支持此功能。

以下代码示例显示了如何读取用于条件格式的图标集。借助 Aspose.Cell 的简单 API，图标集的图像数据将保存为图像。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Open a template Excel file
Workbook workbook = new Workbook(dataDir+ "book1.xlsx");

// Get the first worksheet in the workbook
Worksheet sheet = workbook.Worksheets[0];

// Get the A1 cell
Cell cell = sheet.Cells["A1"];

// Get the conditional formatting result object
ConditionalFormattingResult cfr = cell.GetConditionalFormattingResult();

// Get the icon set
ConditionalFormattingIcon icon = cfr.ConditionalFormattingIcon;

// Create the image file based on the icon's image data
File.WriteAllBytes(dataDir+ "imgIcon.out.jpg", icon.ImageData);