Syncfusion.XlsIO.Base
Example 


IsStrikeThrough Property

Gets or sets a Boolean value indicating whether the font is strike through.
Syntax
'Declaration
 
Property IsStrikeThrough As Boolean
'Usage
 
Dim instance As IConditionalFormat
Dim value As Boolean
 
instance.IsStrikeThrough = value
 
value = instance.IsStrikeThrough
bool IsStrikeThrough {get; set;}
Remarks
Similar to IsStrikeThrough, we can use Underline, IsBold and IsItalic properties to format the values in the cells within the conditional formatting range.
Example
Data in the cells within the conditional formats range can be struck with the help of IsStrikeThrough property. To strike values in the cells, we have to set the IsStrikeThrough property to True.
using Syncfusion.XlsIO;
using System;
using System.Drawing;
            
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;
            
            //Set StrikeThrough.
            format.IsStrikeThrough = true;
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also