Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IConditionalFormat Interface : IsPatternColorPresent Property

IsPatternColorPresent Property

True if pattern color is present. otherwise, False.
Syntax
'Declaration
 
Property IsPatternColorPresent As Boolean
'Usage
 
Dim instance As IConditionalFormat
Dim value As Boolean
 
instance.IsPatternColorPresent = value
 
value = instance.IsPatternColorPresent
bool IsPatternColorPresent {get; set;}
Example
We can use IsPatternColorPresent property to check whether pattern color is set or not. Here for example, we check whether pattern color is set or not before setting and after setting ExcelPattern.DarkHorizontal to FillPattern and ExcelKnownColors.Red to Color.
using Syncfusion.XlsIO;
using System;
            
class Example
{
    static void Main()
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create a worksheet.        
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];
            
            //Load data to Apply Conditional Formatting.
            worksheet["B1"].Text = "Conditional Formats";
            worksheet["B2"].Number = 10;
            worksheet["B3"].Number = 20;
            worksheet["B4"].Number = 30;
            worksheet["B5"].Number = 40;
            worksheet["B6"].Number = 50;
            worksheet["B7"].Number = 60;
            worksheet["B8"].Number = 70;
            worksheet["B9"].Number = 80;
            worksheet["B10"].Number = 90;
            worksheet["B11"].Number = 100;
            
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["B2:B11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            
            //Set Condition.
            format.FirstFormula = "60";
            format.SecondFormula = "20";
            format.Operator = ExcelComparisonOperator.Between;
            
            //Check whether pattern color is set or not.
            Console.WriteLine(format.IsPatternColorPresent);
            
            //Set Color.
            format.Color = ExcelKnownColors.Red;
            format.FillPattern = ExcelPattern.DarkHorizontal;
            
            //Check whether pattern color is set or not.
            Console.WriteLine(format.IsPatternColorPresent);
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
//Output will be
//False
//True
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also