Group And Ungroup Shapes in Excel via Java

Using Aspose.Cells’ API to work with various objects without any software like Microsoft or Open Office, Adobe PDF, etc.

How to Group And Ungroup Shapes in Excel File Using sJava

In order to Group And Ungroup Shapes in excel file, we’ll use

Aspose.Cells for Java

API which is a feature-rich, powerful and easy to use API for Java platform. You can download its latest version directly from

Maven

and install it within your Maven-based project by adding the following configurations to the pom.xml.

Repository
<repository>
<id>AsposeJavaAPI</id>
<name>Aspose Java API</name>
<url>https://repository.aspose.com/repo/</url>
</repository>

Dependency
<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>version of aspose-cells API</version>
<classifier>jdk17</classifier>
</dependency>

Steps to Group And Ungroup Shapes in Excel file via Java

Instantiating a Workbook object.(or->Load the XLSX file with full path.)
Select Worksheet via its index.
Use the group method to group shapes in the selected worksheet
Use the ungroup method to ungroup shapes in the selected worksheet
Save workbook in XLSX format.

System Requirements

Aspose.Cells for Java supports on all major platforms and Operating Systems. Please make sure that you have the following prerequisites.

Microsoft Windows or a compatible OS with Java Runtime Environment for JSP/JSF Application and Desktop Applications.
Get latest version of Aspose.Cells for Java directly from Maven.

Group And Ungroup Shapes - Java

About Aspose.Cells for Java API

Aspose.Cells API can be used to create, edit, convert and render Microsoft Excel formats to different formats. Moreover, it can be used for comprehensive charting, scalable reporting and reliable calculations within software applications. Aspose.Cells is a standalone API and it does not require any software like Microsoft or OpenOffice.