قم بإضافة مجموعة أيقونات شرطية مع نص Cell

في بعض الأحيان ، قد ترغب في إضافة رموز شرطية بجوار النص في خلية لجعل البيانات أكثر أهمية للقراء. تريد استخدام بعض أنواع أيقونات التنسيق الشرطي ولكن بدون تطبيق التنسيق الشرطي على الخلايا. Aspose.Cells يدعم الميزة.

يوضح نموذج التعليمات البرمجية التالي كيفية إضافة رموز شرطية تم تعيينها باستخدام نص Cell.

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