自定义数据透视表的全球化设置

可能的使用场景

有时您想自定义数据透视总计、小计、总计、所有项目、多项、列标签、行标签、空白值文本根据您的要求。 Aspose.Cells 允许您自定义数据透视表的全球化设置以应对此类场景。您还可以使用此功能将标签更改为其他语言，如阿拉伯语、印地语、波兰语等。

自定义数据透视表的全球化设置

以下示例代码说明了如何自定义数据透视表的全球化设置。它创建了一个类自定义数据透视表全球化设置从基类派生全球化设置并覆盖所有必要的方法。这些方法返回自定义的文本数据透视总计、小计、总计、所有项目、多项、列标签、行标签、空白值.然后将这个类的对象赋值给WorkbookSettings.GlobalizationSettings财产。代码加载源文件包含数据透视表，刷新并计算其数据并将其另存为输出 PDF文件。以下屏幕截图显示了示例代码对输出 PDF 的影响。正如您在屏幕截图中看到的那样，数据透视表的不同部分现在具有由重写方法返回的自定义文本全球化设置班级。

示例代码

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
private class CustomPivotTableGlobalizationSettings : PivotGlobalizationSettings
{
    //Gets the name of "Total" label in the PivotTable.
    //You need to override this method when the PivotTable contains two or more PivotFields in the data area.
    public override string GetTextOfTotal()
    {
        Console.WriteLine("---------GetPivotTotalName-------------");
        return "AsposeGetPivotTotalName";
    }

    //Gets the name of "Grand Total" label in the PivotTable.
    public override string GetTextOfGrandTotal()
    {
        Console.WriteLine("---------GetPivotGrandTotalName-------------");
        return "AsposeGetPivotGrandTotalName";
    }

    //Gets the name of "(Multiple Items)" label in the PivotTable.
    public override string GetTextOfMultipleItems()
    {
        Console.WriteLine("---------GetMultipleItemsName-------------");
        return "AsposeGetMultipleItemsName";
    }

    //Gets the name of "(All)" label in the PivotTable.
    public override string GetTextOfAll()
    {
        Console.WriteLine("---------GetAllName-------------");
        return "AsposeGetAllName";
    }

    //Gets the name of "Column Labels" label in the PivotTable.
    public override string GetTextOfColumnLabels()
    {
        Console.WriteLine("---------GetColumnLabelsOfPivotTable-------------");
        return "AsposeGetColumnLabelsOfPivotTable";
    }

    //Gets the name of "Row Labels" label in the PivotTable.
    public override string GetTextOfRowLabels()
    {
        Console.WriteLine("---------GetRowLabelsNameOfPivotTable-------------");
        return "AsposeGetRowLabelsNameOfPivotTable";
    }

    //Gets the name of "(blank)" label in the PivotTable.
    public override string GetTextOfEmptyData()
    {
        Console.WriteLine("---------GetEmptyDataName-------------");
        return "(blank)AsposeGetEmptyDataName";
    }

    //Gets the name of PivotFieldSubtotalType type in the PivotTable.
    public override string GetTextOfSubTotal(PivotFieldSubtotalType subTotalType)
    {
        Console.WriteLine("---------GetSubTotalName-------------");

        switch (subTotalType)
        {
            case PivotFieldSubtotalType.Sum:
                return "AsposeSum";//polish

            case PivotFieldSubtotalType.Count:
                return "AsposeCount";

            case PivotFieldSubtotalType.Average:
                return "AsposeAverage";

            case PivotFieldSubtotalType.Max:
                return "AsposeMax";

            case PivotFieldSubtotalType.Min:
                return "AsposeMin";

            case PivotFieldSubtotalType.Product:
                return "AsposeProduct";

            case PivotFieldSubtotalType.CountNums:
                return "AsposeCount";

            case PivotFieldSubtotalType.Stdev:
                return "AsposeStdDev";

            case PivotFieldSubtotalType.Stdevp:
                return "AsposeStdDevp";

            case PivotFieldSubtotalType.Var:
                return "AsposeVar";

            case PivotFieldSubtotalType.Varp:
                return "AsposeVarp";
        }

        return "AsposeSubTotalName";
    }
}

public static void Run()
{
    // The path to the documents directory.
    string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
                
    //Load your excel file
    Workbook wb = new Workbook(dataDir + "samplePivotTableGlobalizationSettings.xlsx");

    //Setting Custom Pivot Table Globalization Settings
    wb.Settings.GlobalizationSettings.PivotSettings = new CustomPivotTableGlobalizationSettings();

    //Hide first worksheet that contains the data of the pivot table
    wb.Worksheets[0].IsVisible = false;

    //Access second worksheet
    Worksheet ws = wb.Worksheets[1];

    //Access the pivot table, refresh and calculate its data
    PivotTable pt = ws.PivotTables[0];
    pt.RefreshDataFlag = true;
    pt.RefreshData();
    pt.CalculateData();
    pt.RefreshDataFlag = false;

    //Pdf save options - save entire worksheet on a single pdf page
    PdfSaveOptions options = new PdfSaveOptions();
    options.OnePagePerSheet = true;

    //Save the output pdf 
    wb.Save(dataDir + "outputPivotTableGlobalizationSettings.pdf", options);
}