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

        public void DoTest()
        {
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            // Instantiate a workbook object
            Workbook book = new Workbook();
            // Create a worksheet object and get the first worksheet
            Worksheet sheet1 = book.Worksheets[0];
            // Set the first worksheet to _sheet object
              _sheet = sheet1;

            // Call different custom methods
            // These methods exhibits different conditional formatting types with their custom
            // Formattings attributes for MS Excel 2007 .xlsx file format
            AddDefaultIconSet();
            AddIconSet2();
            AddIconSet3();
            AddIconSet4();
            AddIconSet5();
            AddIconSet6();
            AddIconSet7();
            AddIconSet8();
            AddIconSet9();
            AddIconSet10();
            AddIconSet11();
            AddIconSet12();
            AddIconSet13();
            AddIconSet14();
            AddIconSet15();
            AddIconSet16();
            AddIconSet17();
            AddIconSet18();
            AddDefaultColorScale();
            Add3ColorScale();
            Add2ColorScale();
            AddAboveAverage();
            AddAboveAverage2();
            AddAboveAverage3();
            AddTop10_1();
            AddTop10_2();
            AddTop10_3();
            AddTop10_4();
            AddDataBar1();
            AddDataBar2();
            AddContainsText();
            AddNotContainsText();
            AddContainsBlank();
            AddNotContainsBlank();
            AddBeginWith();
            AddEndWith();
            AddContainsError();
            AddNotContainsError();
            AddDuplicate();
            AddUnique();
            AddTimePeriod_1();
            AddTimePeriod_2();
            AddTimePeriod_3();
            AddTimePeriod_4();
            AddTimePeriod_5();
            AddTimePeriod_6();
            AddTimePeriod_7();
            AddTimePeriod_8();
            AddTimePeriod_9();
            AddTimePeriod_10();

            // AutoFit M Column in the worksheet
            _sheet.AutoFitColumn(12);
            // Specify the output file path
            string outfn = dataDir+ "Testoutput.out.xlsx";
            // Save the excel file
            book.Save(outfn, SaveFormat.Xlsx);
        }
        // This method implements the IconSet conditional formatting type with 3 Arrows Colored attribute.

 public static void Run()
 {
     // ExStart:1
     // The path to the documents directory.
     string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
     ConditionalFormatting obj = new ConditionalFormatting();
     obj.DoTest();
 }