刷新数据透视表时指定数据透视表是否兼容Excel2003

Aspose.Cells 提供了数据透视表.IsExcel2003Compatible刷新数据透视表时可用于指定数据透视表是否与 Excel2003 兼容的属性。如果真的 字符串必须小于或等于 255 个字符，因此如果字符串大于 255 个字符，它将被截断。如果错误的，字符串不会有上述限制。默认值为真的.

刷新数据透视表时指定数据透视表是否兼容Excel2003

下面的示例代码解释了数据透视表.IsExcel2003Compatible财产。原始字符串的长度为 383 个字符。但当数据透视表.IsExcel2003Compatible属性设置为真的数据透视表刷新后，数据透视表B5单元格的数据被截断，变成255个字符长。然而，当数据透视表.IsExcel2003Compatible属性已设置错误的再次刷新数据透视表，数据透视表B5单元格的数据没有被截断，仍然是383个字符长。请下载示例 excel 文件在此代码中使用，输出excel文件由它生成及其控制台输出供您参考。另请阅读代码中的注释，以便更好地理解此属性。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the resource directory.
String dataDir = Utils.getSharedDataDir(IsPivotTableCompatibleForExcel2003.class) + "Conversion/";
		
//Load source excel file containing sample pivot table
Workbook wb = new Workbook(dataDir + "sample-pivot-table.xlsx");

//Access first worksheet that contains pivot table data
Worksheet dataSheet = wb.getWorksheets().get(0);

//Access cell A3 and sets its data
Cells cells = dataSheet.getCells();
Cell cell = cells.get("A3");
cell.putValue("FooBar");

//Access cell B3 and sets its data
//We set B3 a very long string which has more than 255 characters
String longStr = "Very long text 1. very long text 2. very long text 3. very long text 4. very long text 5. very long text 6. very long text 7. very long text 8. very long text 9. very long text 10. very long text 11. very long text 12. very long text 13. very long text 14. very long text 15. very long text 16. very long text 17. very long text 18. very long text 19. very long text 20. End of text.";
cell = cells.get("B3");
cell.putValue(longStr);

//Print the length of cell B3 string
System.out.println("Length of original data string: " + cell.getStringValue().length());

//Access cell C3 and sets its data
cell = cells.get("C3");
cell.putValue("closed");

//Access cell D3 and sets its data
cell = cells.get("D3");
cell.putValue("2016/07/21");

//Access the second worksheet that contains pivot table
Worksheet pivotSheet = wb.getWorksheets().get(1);

//Access the pivot table
PivotTable pivotTable = pivotSheet.getPivotTables().get(0);

//IsExcel2003Compatible property tells if PivotTable is compatible for Excel2003 while refreshing PivotTable.
//If it is true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters,
//it will be truncated. If false, a string will not have the aforementioned restriction.
//The default value is true.
pivotTable.setExcel2003Compatible(true);
pivotTable.refreshData();
pivotTable.calculateData();

//Check the value of cell B5 of pivot sheet.
//It will be 255 because we have set IsExcel2003Compatible property to true
//All the data after 255 characters has been truncated
Cell b5 = pivotSheet.getCells().get("B5");
System.out.println("Length of cell B5 after setting IsExcel2003Compatible property to True: " + b5.getStringValue().length());

//Now set IsExcel2003Compatible property to false and again refresh
pivotTable.setExcel2003Compatible(false);
pivotTable.refreshData();
pivotTable.calculateData();

//Now it will print 383 the original length of cell data
//The data has not been truncated now.
b5 = pivotSheet.getCells().get("B5");
System.out.println("Length of cell B5 after setting IsExcel2003Compatible property to False: " + b5.getStringValue().length());

//Set the row height and column width of cell B5 and also wrap its text
pivotSheet.getCells().setRowHeight(b5.getRow(), 100);
pivotSheet.getCells().setColumnWidth(b5.getColumn(), 65);
Style st = b5.getStyle();
st.setTextWrapped(true);
b5.setStyle(st);

//Save workbook in xlsx format
wb.save(dataDir + "output.xlsx", SaveFormat.XLSX);

控制台输出

这是使用给定的执行时上述示例代码的控制台输出示例 excel 文件.

 Length of original data string: 383

Length of cell B5 after setting IsExcel2003Compatible property to True: 255

Length of cell B5 after setting IsExcel2003Compatible property to False: 383