TableStyleCollection.DefaultPivotStyleName

TableStyleCollection.DefaultPivotStyleName property

Gets and sets the default style name of pivot table .

public string DefaultPivotStyleName { get; set; }

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.Tables;

namespace AsposeCellsExamples
{
    public class TableStyleCollectionPropertyDefaultPivotStyleNameDemo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            
            // Access the table styles collection
            TableStyleCollection tableStyles = workbook.Worksheets.TableStyles;
            
            // Display default pivot style name
            Console.WriteLine("Default Pivot Style: " + tableStyles.DefaultPivotStyleName);
            
            // Change the default pivot style
            tableStyles.DefaultPivotStyleName = "PivotStyleDark2";
            
            // Verify the change
            Console.WriteLine("Updated Default Pivot Style: " + tableStyles.DefaultPivotStyleName);
            
            // Save the workbook
            workbook.Save("output.xlsx");
        }
    }
}

See Also