PNG JPG BMP TIFF XLSX

Group And Ungroup Shapes in Excel using Python 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 Python via Java

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

API which is a feature-rich, powerful and easy to use document manipulation API for Python via Java platform.The API provides Excel file creation, manipulation, conversion and rendering. All without relying on Microsoft Office or Excel applications.You can install from the console using the following command.

Command
> pip install aspose-cells

Steps to Group And Ungroup Shapes in Excel file using Python via Java

You need the aspose.cells to try the following workflow in your own environment.

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 Python via Java is platform-independent API and can be used on any platform (Windows, Linux and MacOS), just make sure that system have Java 1.8 or higher, Python 3.5 or higher.

Any operating system that can run Python via Java scripts, such as Windows, Linux and MacOS
Install Java and add it to PATH environment variable, for example: PATH=C:\Program Files\Java\jdk1.8.0_131;.
Install Aspose.Cells for Python via Java from pypi, use command as: $ pip install aspose-cells.

Group And Ungroup Shapes - Python via Java

About Aspose.Cells for Python via 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.