Public API Changes in Aspose.Cells 8.5.1

This document describes the changes to the Aspose.Cells API from version 8.5.0 to 8.5.1 that may be of interest to module/application developers. It includes not only new and updated public methods, added classes etc., but also a description of any changes in the behavior behind the scenes in Aspose.Cells.

Added APIs

Added Workbook.dispose Method

Aspose.Cells for Java 8.5.1 exposes the Workbook.dispose method to release the unmanaged resources of the Workbook object. The dispose pattern is used only for objects that access unmanaged resources, such as file and pipe handles, registry handles, wait handles, or pointers to blocks of unmanaged memory. This is because the garbage collector is very efficient at reclaiming unused managed objects, but it is unable to reclaim unmanaged objects.

Java

 // Create a workbook object
Workbook book = new Workbook();

// Call the dispose method
book.dispose();

Added Cell.getHeightOfValue Method

Aspose.Cells for Java 8.5.1 exposes the Cell.getHeightOfValue method to get the height of a cell’s value. By using this method you can calculate the height of the cell value and then set the height of the row of that cell accordingly. Check the detailed article on how to calculate the cell height & width.

Enumeration TableDataSourceType Added

Aspose.Cells for Java 8.5.1 exposes the enumeration com.aspose.cells.TableDataSourceType to retrieve the data source type of a ListObject. The TableDataSourceType enumeration has the following fields:

1. TableDataSourceType.QUERY_TABLE
2. TableDataSourceType.SHARE_POINT
3. TableDataSourceType.WORKSHEET
4. TableDataSourceType.XML

Added ListObject.DataSourceType Property

With the release of v8.5.1, the Aspose.Cells API exposes the read‑only ListObject.DataSourceType property that can be used to detect the data source type of a ListObject.

Here is the simplest usage scenario.

Java

 Workbook book = new Workbook("D:/book1.xlsx");

Worksheet sheet = book.getWorksheets().get(0);

ListObject listObject = sheet.getListObjects().get(0);

if (listObject.getDataSourceType() == com.aspose.cells.TableDataSourceType.QUERY_TABLE)
{
    System.out.println("Data Source Type is Query Table");
}
else if (listObject.getDataSourceType() == com.aspose.cells.TableDataSourceType.SHARE_POINT)
{
    System.out.println("Data Source Type is SharePoint Linked List");
}
else if (listObject.getDataSourceType() == com.aspose.cells.TableDataSourceType.WORKSHEET)
{
    System.out.println("Data Source Type is Excel Worksheet Table");
}
else if (listObject.getDataSourceType() == com.aspose.cells.TableDataSourceType.XML)
{
    System.out.println("Data Source Type is XML");
}