Aspose.Cells 8.8.0中的公共API更改
添加的 API
获取外部连接的单元引用
Aspose.Cells for Java 8.8.0已公开了以下新属性，可帮助检索存储在电子表格中的外部连接的目标和输出单元格引用。
- QueryTable.ConnectionId: 获取查询表的连接ID。
- ExternalConnection.Id: 获取外部连接的ID。
- ListObject.QueryTable: 获取关联的QueryTable。
添加了HTMLLoadOptions.KeepPrecision属性。
Aspose.Cells for Java 8.8.0已添加HTMLLoadOptions.KeepPrecision属性，以控制在导入HTML文件时将长数字值转换为指数符号的行为。默认情况下，如果从HTML字符串或文件导入数据，任何超过15位数字的值都会被转换为指数符号。不过，现在用户可以通过HTMLLoadOptions.KeepPrecision属性来控制这种行为。如果设置为true，值将按原样导入。
以下是简单的使用场景。
Java
//Sample Html containing large number with digits greater than 15
String html = "<html>"
+ "<body>"
+ "<p>1234567890123456</p>"
+ "</body>"
+ "</html>";
//Convert Html to byte array
byte[] byteArray = html.getBytes();
//Set Html load options and keep precision true
HTMLLoadOptions loadOptions = new HTMLLoadOptions(LoadFormat.HTML);
loadOptions.setKeepPrecision(true);
//Convert byte array into stream
java.io.ByteArrayInputStream stream = new java.io.ByteArrayInputStream(byteArray);
//Create workbook from stream with Html load options
Workbook workbook = new Workbook(stream, loadOptions);
//Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
//Auto fit the sheet columns
worksheet.autoFitColumns();
//Save the workbook
workbook.save(dataDir + "output.xlsx", SaveFormat.XLSX);
添加了HTMLLoadOptions.DeleteRedundantSpaces属性。
Aspose.Cells for Java 8.8.0 has exposed the HTMLLoadOptions.DeleteRedundantSpaces property in order to keep or delete the extra spaces after the line break tag (
Tag) while importing the data from the HTML string or file. The HTMLLoadOptions.DeleteRedundantSpaces property has the default value as false that means, all extra spaces will be preserved and imported to the Workbook object, however, when set to true, the API will delete all the redundant spaces coming after the line break tag.
简单的使用场景如下。
Java
//Sample Html containing redundant spaces after <br> tag
String html = "<html>"
+ "<body>"
+ "<table>"
+ "<tr>"
+ "<td>"
+ "<br> This is sample data"
+ "<br> This is sample data"
+ "<br> This is sample data"
+ "</td>"
+ "</tr>"
+ "</table>"
+ "</body>"
+ "</html>";
//Convert Html to byte array
byte[] byteArray = html.getBytes();
//Set Html load options and keep precision true
HTMLLoadOptions loadOptions = new HTMLLoadOptions(LoadFormat.HTML);
loadOptions.setDeleteRedundantSpaces(true);
//Convert byte array into stream
java.io.ByteArrayInputStream stream = new java.io.ByteArrayInputStream(byteArray);
//Create workbook from stream with Html load options
Workbook workbook = new Workbook(stream, loadOptions);
//Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
//Auto fit the sheet columns
worksheet.autoFitColumns();
//Save the workbook
workbook.save(dataDir + "output-" + loadOptions.getDeleteRedundantSpaces() + ".xlsx", SaveFormat.XLSX);
添加了Style.QuotePrefix属性。
Aspose.Cells for Java 8.8.0已公开了Style.QuotePrefix属性，以检测单元格值是否以单引号符号开头。
简单的使用场景如下。
Java
//Create an instance of workbook
Workbook workbook = new Workbook();
//Access first worksheet from the collection
Worksheet worksheet = workbook.getWorksheets().get(0);
//Access cells A1 and A2
Cell a1 = worksheet.getCells().get("A1");
Cell a2 = worksheet.getCells().get("A2");
//Add simple text to cell A1 and text with quote prefix to cell A2
a1.putValue("sample");
a2.putValue("'sample");
//Print their string values, A1 and A2 both are same
System.out.println("String value of A1: " + a1.getStringValue());
System.out.println("String value of A2: " + a2.getStringValue());
//Access styles of cells A1 and A2
Style s1 = a1.getStyle();
Style s2 = a2.getStyle();
System.out.println();
//Check if A1 and A2 has a quote prefix
System.out.println("A1 has a quote prefix: " + s1.getQuotePrefix());
System.out.println("A2 has a quote prefix: " + s2.getQuotePrefix());
已弃用的API
弃用了LoadOptions.ConvertNumericData属性
Aspose.Cells 8.8.0已将LoadOptions.ConvertNumericData属性标记为弃用。请使用HTMLLoadOptions或TxtLoadOptions类中的相应属性。