Добавление условных значков к тексту ячейки

Иногда вам нужно добавить условные значки рядом с текстом в ячейке, чтобы сделать данные более понятными для читателей. Вы хотите использовать некоторые типы значков условного форматирования, но без применения условного форматирования к ячейкам. Aspose.Cells поддерживает эту функцию.

В следующем примере кода показано, как добавить условные значки к тексту ячейки.

// 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);

// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
    System.IO.Directory.CreateDirectory(dataDir);

// Instantiate a new Workbook
Workbook workbook = new Workbook();
// Get the first worksheet (default worksheet) in the workbook
Worksheet worksheet = workbook.Worksheets[0];
// Get the cells
Cells cells = worksheet.Cells;
// Set the columns widths (A, B and C)
worksheet.Cells.SetColumnWidth(0, 24);
worksheet.Cells.SetColumnWidth(1, 24);
worksheet.Cells.SetColumnWidth(2, 24);

// Input date into the cells
cells["A1"].PutValue("KPIs");
cells["A2"].PutValue("Total Turnover (Sales at List)");
cells["A3"].PutValue("Total Gross Margin %");
cells["A4"].PutValue("Total Net Margin %");
cells["B1"].PutValue("UA Contract Size Group 4");
cells["B2"].PutValue(19551794);
cells["B3"].PutValue(11.8070745566204);
cells["B4"].PutValue(11.858589818569);
cells["C1"].PutValue("UA Contract Size Group 3");
cells["C2"].PutValue(8150131.66666667);
cells["C3"].PutValue(10.3168384396244);
cells["C4"].PutValue(11.3326931937091);

// Get the conditional icon's image data
byte[] imagedata = ConditionalFormattingIcon.GetIconImageData(IconSetType.TrafficLights31, 0);
// Create a stream based on the image data
MemoryStream stream = new MemoryStream(imagedata);
// Add the picture to the cell based on the stream
worksheet.Pictures.Add(1, 1, stream);

// Get the conditional icon's image data
byte[] imagedata1 = ConditionalFormattingIcon.GetIconImageData(IconSetType.Arrows3, 2);
// Create a stream based on the image data
MemoryStream stream1 = new MemoryStream(imagedata1);
// Add the picture to the cell based on the stream
worksheet.Pictures.Add(1, 2, stream1);

// Get the conditional icon's image data
byte[] imagedata2 = ConditionalFormattingIcon.GetIconImageData(IconSetType.Symbols3, 0);
// Create a stream based on the image data
MemoryStream stream2 = new MemoryStream(imagedata2);
// Add the picture to the cell based on the stream
worksheet.Pictures.Add(2, 1, stream2);

// Get the conditional icon's image data
byte[] imagedata3 = ConditionalFormattingIcon.GetIconImageData(IconSetType.Stars3, 0);
// Create a stream based on the image data
MemoryStream stream3 = new MemoryStream(imagedata3);
// Add the picture to the cell based on the stream
worksheet.Pictures.Add(2, 2, stream3);

// Get the conditional icon's image data
byte[] imagedata4 = ConditionalFormattingIcon.GetIconImageData(IconSetType.Boxes5, 1);
// Create a stream based on the image data
MemoryStream stream4 = new MemoryStream(imagedata4);
// Add the picture to the cell based on the stream
worksheet.Pictures.Add(3, 1, stream4);

// Get the conditional icon's image data
byte[] imagedata5 = ConditionalFormattingIcon.GetIconImageData(IconSetType.Flags3, 1);
// Create a stream based on the image data
MemoryStream stream5 = new MemoryStream(imagedata5);
// Add the picture to the cell based on the stream
worksheet.Pictures.Add(3, 2, stream5);

dataDir = dataDir + "outfile_cond_icons1.out.xlsx";
// Save the Excel file
workbook.Save(dataDir);