Public API Changes in Aspose.Cells 8.4.2

Added APIs

Improved Chart Creation Mechanism

The com.aspose.cells.charts.Chart class has exposed the setChartDataRange method to ease the task of chart creation. The setChartDataRange method accepts two parameters, where the first parameter is of type String that specifies the cell area from which to plot the data series. The second parameter is of type Boolean that specifies the plot orientation, that is, whether to plot the chart data series from a range of cell values by row or by columns.

The following code snippet shows how to create a column chart with a few lines of code, assuming the chart’s plot series data is present on the same worksheet from cell A1 to D4.

Java

 //Add a new chart of type Column to chart collection
int idx = worksheet.getCharts().add(ChartType.COLUMN, 6, 5, 20, 13);

//Retrieve the newly added chart instance
Chart chart = worksheet.getCharts().get(idx);

//Specify the chart's data series from cell A1 to D4
chart.setChartDataRange("A1:D4", true);

Added VbaModuleCollection.add Method

Aspose.Cells for Java 8.4.2 has exposed the VbaModuleCollection.add method to add a new VBA module to an instance of Workbook. The VbaModuleCollection.add method accepts a parameter of type Worksheet to add a worksheet‑specific module.

The following code snippet shows how to use the VbaModuleCollection.add method.

Java

 //Create new workbook
Workbook workbook = new Workbook();

//Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

//Add VBA module
int idx = workbook.getVbaProject().getModules().add(worksheet);

//Access the VBA Module, set its name and code
VbaModule module = workbook.getVbaProject().getModules().get(idx);
module.setName("TestModule");
module.setCodes("Sub ShowMessage()" + "\r\n" +
    "    MsgBox \"Welcome to Aspose!\"" + "\r\n" +
    "End Sub");

//Save the workbook
workbook.save(output, SaveFormat.XLSM);

Overloaded Method Cells.copyColumns Added

Aspose.Cells for Java 8.4.2 has exposed an overloaded version of the Cells.copyColumns method to repeat the source columns onto the destination. The newly exposed method accepts five parameters in total, where the first four parameters are the same as those of the common Cells.copyColumns method. The last parameter, of type int, specifies the number of destination columns onto which the source columns have to be repeated.

The following code snippet shows how to use the newly exposed Cells.copyColumns method.

Java

 //Load an existing workbook
Workbook workbook = new Workbook(input);

//Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

//Access cells of first worksheet
Cells cells = worksheet.getCells();

//Copy the first two columns (A & B) along with formatting
//to columns G, H & I.
//Please note, columns G & H will be replaced by A & B respectively,
//whereas column I will be replaced by column A.
cells.copyColumns(cells, 0, 2, 6, 3);

//Save the workbook
workbook.save(output);

Enumeration Fields PasteType.DEFAULT & PasteType.ALL_EXCEPT_BORDERS Added

With the release of v8.4.2, the Aspose.Cells API has added two new enumeration fields for PasteType as detailed below.

  • PasteType.DEFAULT: Works similarly to Excel’s All functionality for pasting a range of cells.
  • PasteType.ALL_EXCEPT_BORDERS: Works similarly to Excel’s All except borders functionality for pasting a range of cells.

The following sample code demonstrates the use of the PasteType.DEFAULT field.

Java

 //Load an existing workbook
Workbook workbook = new Workbook(input);

//Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

//Access cells of first worksheet
Cells cells = worksheet.getCells();

//Create source & destination ranges
Range source = cells.createRange("A1:B6");
Range destination = cells.createRange("D1:E6");

//Create an instance of PasteOptions and set its PasteType property
PasteOptions options = new PasteOptions();
options.setPasteType(PasteType.DEFAULT);

//Copy the source range onto the destination range with everything except column widths
destination.copy(source, options);

//Save the workbook
workbook.save(output);

Public API Changes in Aspose.Cells 8.4.1 Public API Changes in Aspose.Cells 8.5.0