Public API Changes in Aspose.Cells 8.6.2

Added APIs

Support for Call Back with Smart Markers

This release of Aspose.Cells for Java API has exposed the WorkbookDesigner.CallBack field and ISmartMarkerCallBack interface that together allows to get the notifications about the cell reference and/or smart marker being processed. Following piece of code demonstrates the usage of ISmartMarkerCallBack interface to define a new class that handles the call back for WorkbookDesigner.process method.

Java

 public class SmartMarkerCallBack implements ISmartMarkerCallBack 

{

	Workbook workbook;

	SmartMarkerCallBack(Workbook workbook)

	{

	    this.workbook = workbook;

	}



	@Override

	public void process(int sheetIndex, int rowIndex, int colIndex, String tableName, String columnName)

	{

	    System.out.println("Processing Cell : " + workbook.getWorksheets().get(sheetIndex).getName() + "!" + CellsHelper.cellIndexToName(rowIndex, colIndex));

	    System.out.println("Processing Marker : " + tableName + "." + columnName);

	}

}

Rest of the process includes loading the designer spreadsheet containing the Smart Markers with WorkbookDesigner or creating one from scratch and process it by setting the data source. However, in order to enable the notifications, it is necessary to set the WorkbookDesigner.CallBack property before calling the WorkbookDesigner.process method as demonstrated below.

Java

 //Instantiate a new Workbook designer

WorkbookDesigner report = new WorkbookDesigner();

//Get the first worksheet of the workbook

Worksheet sheet = report.getWorkbook().getWorksheets().get(0);

//Set the Variable Array marker to a cell

//You may also place this Smart Marker into a template file manually using Excel and then open this file via WorkbookDesigner 

sheet.getCells().get("A1").putValue("&=$VariableArray");

//Set the data source for the marker(s)

report.setDataSource("VariableArray", new String[] { "English", "Arabic", "Hindi", "Urdu", "French" });

//Set the CallBack property

report.setCallBack(new SmartMarkerCallBack(report.getWorkbook()));

//Process the markers

report.process(false);

Method Chart.toPdf Added

Aspose.Cells for Java 8.6.2 has exposed the Chart.toPdf method that can be used to directly render the Chart shape to PDF format. The said method currently accepts a parameter of of type String as file path location to store the resultant file on disk.

Following is the simple usage scenario.

Java

 //Load spreadsheet containing charts

Workbook workbook = new Workbook(inputFilePath);

//Access first worksheet

Worksheet worksheet = workbook.getWorksheets().get(0);

//Access first chart inside the worksheet

Chart chart = worksheet.getCharts().get(0);

//Save the chart in PDF format

chart.toPdf(outputFilePath);

Method Workbook.removeUnusedStyles Added

Aspose.Cells for Java 8.6.2 has exposed the Workbook.removeUnusedStyles method that can be used to remove all unused Style objects from the pool of styles.

Following is the simple usage scenario.

Java

 //Load spreadsheet

Workbook workbook = new Workbook(inputFilePath);

//Remove all unused styles from the template

workbook.removeUnusedStyles();

Property Cells.Style Added

The Cells.Style property can be used to access the Style for the Worksheet representing the default style.

Following is the simple usage scenario.

Java

 //Load a spreadsheet

Workbook book = new Workbook(inputFilePath);

//Access the default style of worksheet

Style style = book.getWorksheets().get(0).getCells().getStyle();

Events Added for GridWeb

Aspose.Cells.GridWeb for Java 8.6.2 has exposed the following two new events.

  1. AjaxCallFinished: Fires when the AJAX update of the control finished. (EnableAJAX should be set to true).
  2. CellModifiedOnAjax: Fires when the cell is modified in AJAX call.