PivotConditionalFormat.RuleType
PivotConditionalFormat.RuleType property
Get and set rule type for the pivot table condition format .
public PivotConditionFormatRuleType RuleType { get; set; }
Examples
namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using Aspose.Cells.Pivot;
    using System;
    public class PivotConditionalFormatPropertyRuleTypeDemo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];
            try
            {
                // Create minimal data for pivot table
                worksheet.Cells["A1"].Value = "Category";
                worksheet.Cells["A2"].Value = "Value";
                // Create pivot table
                int pivotIndex = worksheet.PivotTables.Add("A1:A2", "C3", "DemoPivotTable");
                PivotTable pivotTable = worksheet.PivotTables[pivotIndex];
                // Add conditional format
                int formatIndex = pivotTable.ConditionalFormats.Add();
                PivotConditionalFormat format = pivotTable.ConditionalFormats[formatIndex];
                // Demonstrate RuleType property
                Console.WriteLine("Initial RuleType: " + format.RuleType);
                
                // Set new rule type
                format.RuleType = PivotConditionFormatRuleType.Row;
                Console.WriteLine("Updated RuleType: " + format.RuleType);
                workbook.Save("RuleTypeDemo.xlsx");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error: {ex.Message}");
            }
        }
    }
}
See Also
- enum PivotConditionFormatRuleType
- class PivotConditionalFormat
- namespace Aspose.Cells.Pivot
- assembly Aspose.Cells