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

可能的使用场景

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

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

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

示例代码

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
public class CustomizeGlobalizationSettingsforPivotTable {
	
	class CustomPivotTableGlobalizationSettings extends GlobalizationSettings
	{   
	    //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 String getPivotTotalName()
	    {
	        System.out.println("---------GetPivotTotalName-------------");
	        return "AsposeGetPivotTotalName";
	    }
	  
	    //Gets the name of "Grand Total" label in the PivotTable.
	    public String getPivotGrandTotalName()
	    {
	        System.out.println("---------GetPivotGrandTotalName-------------");
	        return "AsposeGetPivotGrandTotalName";
	    }
	  
	    //Gets the name of "(Multiple Items)" label in the PivotTable.
	    public String getMultipleItemsName()
	    {
	        System.out.println("---------GetMultipleItemsName-------------");
	        return "AsposeGetMultipleItemsName";
	    }
	  
	    //Gets the name of "(All)" label in the PivotTable.
	    public String getAllName()
	    {
	        System.out.println("---------GetAllName-------------");
	        return "AsposeGetAllName";
	    }
	  
	    //Gets the name of "Column Labels" label in the PivotTable.
	    public String getColumnLabelsOfPivotTable()
	    {
	        System.out.println("---------GetColumnLabelsOfPivotTable-------------");
	        return "AsposeGetColumnLabelsOfPivotTable";
	    }
	  
	    //Gets the name of "Row Labels" label in the PivotTable.
	    public String getRowLabelsNameOfPivotTable()
	    {
	        System.out.println("---------GetRowLabelsNameOfPivotTable-------------");
	        return "AsposeGetRowLabelsNameOfPivotTable";
	    }
	  
	    //Gets the name of "(blank)" label in the PivotTable.
	    public String getEmptyDataName()
	    {
	        System.out.println("---------GetEmptyDataName-------------");
	        return "(blank)AsposeGetEmptyDataName";
	    }
	  
	    //Gets the name of PivotFieldSubtotalType type in the PivotTable.
	    public String getSubTotalName(int subTotalType)
	    {
	        System.out.println("---------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.COUNT_NUMS:
	                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 void RunCustomizeGlobalizationSettingsforPivotTable() throws Exception
	{
		// The path to the documents directory.
		String dataDir = Utils.getSharedDataDir(CustomizeGlobalizationSettingsforPivotTable.class) + "PivotTables/";
		
		//Load your excel file
		Workbook wb = new Workbook(dataDir + "samplePivotTableGlobalizationSettings.xlsx");
		  
		//Setting Custom Pivot Table Globalization Settings
		wb.getSettings().setGlobalizationSettings(new CustomPivotTableGlobalizationSettings());
		  
		//Hide first worksheet that contains the data of the pivot table
		wb.getWorksheets().get(0).setVisible(false);
		  
		//Access second worksheet
		Worksheet ws = wb.getWorksheets().get(1);
		  
		//Access the pivot table, refresh and calculate its data
		PivotTable pt = ws.getPivotTables().get(0);
		pt.setRefreshDataFlag(true);
		pt.refreshData();
		pt.calculateData();
		pt.setRefreshDataFlag(false);
		  
		//Pdf save options - save entire worksheet on a single pdf page
		PdfSaveOptions options = new PdfSaveOptions();
		options.setOnePagePerSheet(true);
		  
		//Save the output pdf 
		wb.save(dataDir + "outputPivotTableGlobalizationSettings.pdf", options);

	}

	public static void main(String[] args) throws Exception {
		CustomizeGlobalizationSettingsforPivotTable pg = new CustomizeGlobalizationSettingsforPivotTable();
		pg.RunCustomizeGlobalizationSettingsforPivotTable();
	}