Add Cells to Watch Window and Manipulate Slicers using Aspose.Cells for Java 18.6

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.Cells for JavaWe are pleased to announce the release of Aspose.Cells for Java 18.6. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. We also recommend our clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Please check the release notes in order to get an idea about what is new and what has been fixed with this revision of Aspose.Cells for Java. Here is a look at the major features in this release.

Add Cells to Microsoft Excel Formula Watch Window

Microsoft Excel Watch Window is a useful tool to watch the cell values and its formulas conveniently in a window. You can open the Watch Window using Microsoft Excel by clicking the Formulas > Watch Window. It has Add Watch button that can be used to add the cells for inspection. Similarly, you can use Worksheet.getCellWatches().add() method to add cells into Watch Window using Aspose.Cells API. Please see the following article for more detail on this topic.

Working with Slicers using Aspose.Cells API

Slicers are used to filter data quickly. It provides buttons that user can click to filter Table or Pivot Table data. Whenever, Slicer buttons are selected or deselected, it shows the current filtering state that helps the user to understand what precisely has been filtered in the Pivot Table. Please see the following articles that explain how to work with Slicers using Aspose API.

The following sample code loads an Excel file that contains an existing Slicer. It unselects the 2nd and 3rd items of Slicer to refresh it. It then applies formatting/style of the Slicer and finally describes on how to remove the Slicer.

// Load sample Excel file containing slicer.
Workbook wb = new Workbook("sampleUpdatingSlicer.xlsx");
 
// Access first worksheet.
Worksheet ws = wb.getWorksheets().get(0);
 
// Access the first slicer inside the slicer collection.
Slicer slicer = ws.getSlicers().get(0);
 
// Access the slicer items.
SlicerCacheItemCollection scItems = slicer.getSlicerCache().getSlicerCacheItems();
 
// Unselect 2nd and 3rd slicer items.
scItems.get(1).setSelected(false);
scItems.get(2).setSelected(false);
 
// Refresh the slicer.
slicer.refresh();

// Set the slicer style/formatting.
slicer.setStyleType(SlicerStyleType.SLICER_STYLE_LIGHT_6);

// Remove slicer.
ws.getSlicers().remove(slicer);

Add Custom XML Parts and Select them by ID

Custom XML Parts are the XML data that is stored inside the Microsoft Excel documents and are used by the applications that deal with them. There is no direct way of adding them using Microsoft Excel UI at the moment. However, you can add them programmatically in various ways e.g. using VSTO, using Aspose.Cells etc. Please use Workbook.getCustomXmlParts().add() method if you want to add Custom XML Part using Aspose.Cells API. You can also set its ID, using the CustomXmlPart.ID property. Similarly, if you want to select Custom XML Part by ID, you can use Workbook.getCustomXmlParts().selectByID() method.

Get Address, CellCount Offset, EntireColumn and EntireRow of the Range

Aspose.Cells has added few new utility methods inside the Range object that help the user finding Address, Cell Count, Offset, Entire Column and Entire Row of the Range object. Please see the following article for more detail on this.

Extract Text from the Gear Type SmartArt Shape

Aspose.Cells can extract text from the Gear Type Smart Art Shape. In order to do so, you should first convert Smart Art Shape to Group Shape using the Shape.getResultOfSmartArt() method. Then you should get the array of all the Individual Shapes forming the Group Shape using the GroupShape.getGroupedShapes() method. Finally, you can iterate all of Individual Shapes one by one in a loop and extract their text using the Shape.getText() method.

Aspose.Cells for Java Resources

The resources, you may need to accomplish your tasks:


To keep up with our news, you can follow us on Twitter or follow our Facebook page.