Aspose.Cells.Examples.CSharp.Formatting.ConditionalFormatting.AddTimePeriod_7 C# (CSharp) Метод

        private void AddTimePeriod_7()
        {
            FormatConditionCollection conds = GetFormatCondition("I13:K14", Color.MediumBlue);
            int idx = conds.AddCondition(FormatConditionType.TimePeriod);
            FormatCondition cond = conds[idx];
            cond.Style.BackgroundColor = Color.Pink;
            cond.Style.Pattern = BackgroundType.Solid;
            cond.TimePeriod = TimePeriodType.ThisMonth;
            Cell c = _sheet.Cells["I13"];
            Style style = c.GetStyle();
            style.Number = 30;
            c.SetStyle(style);
            c.PutValue(DateTime.Parse("2008/07/5"));
            c = _sheet.Cells["K14"];
            c.PutValue(DateTime.Parse("2008/05/30"));
             style = c.GetStyle();
            style.Number = 30;
            c.SetStyle(style);

            c = _sheet.Cells["I14"];
            c.PutValue("ThisMonth");
        }