Aspose.Cells 8.7.0中的公共API更改
添加的 API
支持PDF优化
Aspose.Cells API已经提供了将电子表格转换为PDF的功能。通过此API的此版本，用户现在还可以优化生成的PDF大小。Aspose.Cells for Java 8.7.0已公开了PdfSaveOptions.OptimizationType属性以及PdfOptimizationType枚举，以便用户选择导出电子表格到PDF格式时所需的优化算法。PdfSaveOptions.OptimizationType属性有两个可能的值，如下所述。
- PdfOptimizationType.MINIMUM_SIZE: 为了结果文件大小而牺牲质量。
- PdfOptimizationType.STANDARD: 质量不会减少，因此结果文件大小会很大。
以下是简单的使用场景。
Java
//Create an instance of PdfSaveOptions
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
//Set the OptimizationType property to desired value
pdfSaveOptions.setOptimizationType(PdfOptimizationType.MINIMUM_SIZE);
//Create an instance of Workbook
//Optionally load an existing spreadsheet
Workbook book = new Workbook(inFilePath);
//Save the spreadsheet in PDF format while passing the instance of PdfSaveOptions
book.save(outFilePath, pdfSaveOptions);
检测数字签名的VBA项目
新暴露的VbaProject.isSigned属性可以用于检测工作簿中的VBA项目是否数字签名。VbaProject.isSigned属性是布尔类型，如果VBA项目被数字签名则返回true，反之亦然。
以下是简单的使用场景。
Java
//Create an instance of Workbook and load an existing spreadsheet
Workbook book = new Workbook(inFilePath);
//Access the VbaProject from the Workbook
VbaProject vbaProject = book.getVbaProject();
//Check if VbaProject is digitally signed
if (vbaProject.isSigned())
{
System.out.println("VbaProject is digitally signed");
}
else
{
System.out.println("VbaProject is not digitally signed");
}
添加了 Protection.verifyPassword 方法
Aspose.Cells API 通过引入 verifyPassword 方法增强了 Protection 类，允许将密码指定为 String 实例，并且验证是否使用相同的密码来保护工作表。Protection.verifyPassword 方法返回 true，如果指定的密码与用于保护给定工作表的密码匹配，并且如果指定的密码不匹配，则返回 false。以下代码片段使用 Protection.verifyPassword 方法与 Protection.isProtectedWithPassword 字段结合使用以检测密码保护并验证密码。
以下是简单的使用场景。
Java
//Create an instance of Workbook and load a spreadsheet
Workbook book = new Workbook(inFilePath);
//Access the protected Worksheet
Worksheet sheet = book.getWorksheets().get(0);
//Check if Worksheet is password protected
if (sheet.getProtection().isProtectedWithPassword())
{
//Verify the password used to protect the Worksheet
if (sheet.getProtection().verifyPassword("password"))
{
System.out.println("Specified password has matched");
}
else
{
System.out.println("Specified password has not matched");
}
}
添加了 Protection.isProtectedWithPassword 属性
此版本的Aspose.Cells for Java还公开了Protection.isProtectedWithPassword字段，可用于检测工作表是否受密码保护。
以下是简单的使用场景。
Java
//Create an instance of Workbook and load an existing spreadsheet
Workbook book = new Workbook(inFilePath);
//Access the desired Worksheet via its index or name
Worksheet sheet = book.getWorksheets().get(0);
//Access Protection module of desired Worksheet
Protection protection = sheet.getProtection();
//Check if Worksheet is password protected
if (protection.isProtectedWithPassword())
{
System.out.println("Worksheet is password protected");
}
else
{
System.out.println("Worksheet is not password protected");
}
添加了 ColorScale.Is3ColorScale 属性
Aspose.Cells for Java 8.7.0已公开了ColorScale.Is3ColorScale属性，可用于创建2色标度条件格式。该属性是Boolean类型，默认值为true，这意味着条件格式默认为3色标度。不过，将ColorScale.Is3ColorScale属性切换为false会生成2色标度条件格式。
以下是简单的使用场景。
Java
//Create an instance of Workbook
//Optionally load an existing spreadsheet
Workbook book = new Workbook();
//Access the Worksheet to which conditional formatting rule has to be added
Worksheet sheet = book.getWorksheets().get(0);
//Add FormatConditions to the collection
int index = sheet.getConditionalFormattings().add();
//Access newly added formatConditionCollection via its index
FormatConditionCollection formatConditionCollection = sheet.getConditionalFormattings().get(index);
//Create a CellArea on which conditional formatting rule will be applied
CellArea cellArea = CellArea.createCellArea("A1", "A5");
//Add conditional formatted cell range
formatConditionCollection.addArea(cellArea);
//Add format condition of type ColorScale
index = formatConditionCollection.addCondition(FormatConditionType.COLOR_SCALE);
//Access newly added format condition via its index
FormatCondition formatCondition = formatConditionCollection.get(index);
//Set Is3ColorScale to false in order to generate a 2-Color Scale format
formatCondition.getColorScale().setIs3ColorScale(false);
//Set other necessary properties
添加了 TxtLoadOptions.HasFormula 属性
Aspose.Cells for Java 8.7.0支持识别和解析带有分隔纯数据的CSV/TXT文件中的公式。新公开的TxtLoadOptions.HasFormula属性设置为true时，指示API从输入的分隔文件中解析公式，并将其设置到相关单元格，无需进行任何额外的处理。
以下是简单的使用场景。
Java
//Create an instance of TxtLoadOptions
TxtLoadOptions options = new TxtLoadOptions();
//Set HasFormula property to true
options.setHasFormula(true);
//Set the Separator property as desired
options.setSeparator(',');
//Load the CSV/TXT file using the instance of TxtLoadOptions
Workbook book = new Workbook(inFilePath, options);
//Calculate formulas in order to get the calculated values of formula in CSV
book.calculateFormula();
//Write result in any of the supported formats
book.save(outFilePath);
添加了 DataLabels.ResizeShapeToFitText 属性
Aspose.Cells for Java 8.7.0还公开了DataLabels.ResizeShapeToFitText属性，可启用Excel应用程序的图表数据标签的调整形状以适应文字功能。
以下是简单的使用场景。
Java
//Create an instance of Workbook containing the Chart
Workbook book = new Workbook(inFilePath);
//Access the Worksheet that contains the Chart
Worksheet sheet = book.getWorksheets().get(0);
//Access the desired Chart via its index or name
Chart chart = sheet.getCharts().get(0);
//Access the DataLabels of desired NSeries
DataLabels labels = chart.getNSeries().get(0).getDataLabels();
//Set ResizeShapeToFitText property to true
labels.setResizeShapeToFitText(true);
//Calculate Chart
chart.calculate();
删除了 API
已删除 Workbook.SaveOptions 属性
Workbook.SaveOptions 属性已被标记为过时，因此在此版本中已从公共 API 中完全删除，建议使用 Workbook.save(Stream, SaveOptions) 或 Workbook.save(string, SaveOptions) 方法作为替代。