ConditionalFormattingIconCollection

ConditionalFormattingIconCollection class

يمثل مجموعة منConditionalFormattingIcon الكائنات .

public class ConditionalFormattingIconCollection : CollectionBase<ConditionalFormattingIcon>

الخصائص

اسموصف
Capacity { get; set; }
Count { get; }
Item { get; }الحصول على عنصر ConditionalFormattingIcon بالفهرس المحدد.
Item { get; set; }

طُرق

اسموصف
Add(ConditionalFormattingIcon)يضيفConditionalFormattingIcon الكائن .
Add(IconSetType, int)يضيفConditionalFormattingIcon الكائن .
BinarySearch(ConditionalFormattingIcon)
BinarySearch(ConditionalFormattingIcon, IComparer<ConditionalFormattingIcon>)
BinarySearch(int, int, ConditionalFormattingIcon, IComparer<ConditionalFormattingIcon>)
Clear()
Contains(ConditionalFormattingIcon)
CopyTo(ConditionalFormattingIcon[])
CopyTo(ConditionalFormattingIcon[], int)
CopyTo(int, ConditionalFormattingIcon[], int, int)
Exists(Predicate<ConditionalFormattingIcon>)
Find(Predicate<ConditionalFormattingIcon>)
FindAll(Predicate<ConditionalFormattingIcon>)
FindIndex(Predicate<ConditionalFormattingIcon>)
FindIndex(int, Predicate<ConditionalFormattingIcon>)
FindIndex(int, int, Predicate<ConditionalFormattingIcon>)
FindLast(Predicate<ConditionalFormattingIcon>)
FindLastIndex(Predicate<ConditionalFormattingIcon>)
FindLastIndex(int, Predicate<ConditionalFormattingIcon>)
FindLastIndex(int, int, Predicate<ConditionalFormattingIcon>)
GetEnumerator()
IndexOf(ConditionalFormattingIcon)
IndexOf(ConditionalFormattingIcon, int)
IndexOf(ConditionalFormattingIcon, int, int)
LastIndexOf(ConditionalFormattingIcon)
LastIndexOf(ConditionalFormattingIcon, int)
LastIndexOf(ConditionalFormattingIcon, int, int)
RemoveAt(int)

أمثلة


[C#]

// إنشاء كائن مصنف
Workbook workbook = new Workbook();

Worksheet sheet = workbook.Worksheets[0];

// احصل على تنسيق شرطي
ConditionalFormattingCollection cformattings = sheet.ConditionalFormattings;

// يضيف تنسيقًا شرطيًا فارغًا
int index = cformattings.Add();

// احصل على تنسيق شرطي مضاف حديثًا
FormatConditionCollection fcs = cformattings[index];

// يعين نطاق التنسيق الشرطي.
CellArea ca = new CellArea();

ca.StartRow = 0;

ca.EndRow = 0;

ca.StartColumn = 0;

ca.EndColumn = 0;

fcs.AddArea(ca);

ca = new CellArea();

ca.StartRow = 1;

ca.EndRow = 1;

ca.StartColumn = 1;

ca.EndColumn = 1;

fcs.AddArea(ca);

// يعين الشرط
 int idx = fcs.AddCondition(FormatConditionType.IconSet);
 
 FormatCondition cond = fcs[idx];
   
 // يعين الشرط's type
 cond.IconSet.Type = IconSetType.ArrowsGray3;

// إضافة حالة رموز مخصصة.
 ConditionalFormattingIcon cfIcon = cond.IconSet.CfIcons[0];
 
 cfIcon.Type = IconSetType.Arrows3;
 
 cfIcon.Index = 0;
 
 ConditionalFormattingIcon cfIcon1 = cond.IconSet.CfIcons[1];
 
  cfIcon1.Type = IconSetType.ArrowsGray3;
  
  cfIcon1.Index = 1;
  
  ConditionalFormattingIcon cfIcon2 = cond.IconSet.CfIcons[2];
  
  cfIcon2.Type = IconSetType.Boxes5;
  
  cfIcon2.Index = 2;

// حفظ ملف Excel
workbook.Save("output.xls");

[VB.NET]

'إنشاء كائن مصنف
Dim workbook As Workbook = New Workbook()

Dim sheet As Worksheet = workbook.Worksheets(0)

'احصل على تنسيق شرطي
Dim cformattings As ConditionalFormattingCollection = sheet.ConditionalFormattings

'يضيف تنسيقًا شرطيًا فارغًا
Dim index As Integer = cformattings.Add()

'احصل على تنسيق شرطي مضاف حديثًا
Dim fcs As FormatConditionCollection = cformattings(index)

'يضبط نطاق التنسيق الشرطي.
Dim ca As New CellArea()

ca.StartRow = 0

ca.EndRow = 0

ca.StartColumn = 0

ca.EndColumn = 0

fcs.AddArea(ca)

ca = New CellArea()

ca.StartRow = 1

ca.EndRow = 1

ca.StartColumn = 1

ca.EndColumn = 1

fcs.AddArea(ca)

// يعين الشرط
Dim idx As Integer =fcs.AddCondition(FormatConditionType.IconSet)

Dim cond As FormatCondition=fcs[idx]

// يعين الشرط's type
cfIcon.Type = IconSetType.ArrowsGray3

'إضافة حالة رموز مخصصة.
Dim cfIcon As ConditionalFormattingIcon = cond.IconSet.CfIcons[0]

cfIcon.Type = IconSetType.Arrows3

cfIcon.Index=0

Dim cfIcon1 As ConditionalFormattingIcon = cond.IconSet.CfIcons[1]

cfIcon1.Type = IconSetType.ArrowsGray3

cfIcon1.Index=1

Dim cfIcon2 As ConditionalFormattingIcon = cond.IconSet.CfIcons[2]

cfIcon2.Type = IconSetType.Boxes5

cfIcon2.Index=2

'حفظ ملف Excel
workbook.Save("output.xls")

أنظر أيضا

ConditionalFormattingIcon ConditionalFormattingResult