This tutorial guides on how to unmerge cells in Excel using Java REST API. You will learn how to unmerge cells in Excel using Java Low Code API with Java-based Cloud SDK. It will also discuss about the contents state before and after the unmerging operation.
Prerequisite
- Create an account and get API credentials for un-merging cells
- Download Aspose.Cells Cloud SDK for Java to split cells
- Setup Java project with the above SDK
Steps to Unmerge Cells using Java REST Interface
- Create an instance of CellsApi with your Aspose Cloud credentials to enable access to the Aspose.Cells Cloud features
- Prepares a request to upload the local Excel file to Aspose Cloud storage
- Unmerge cells in the range using PostWorksheetUnmerge() from Row 5, Column 5 to Row 7 and Column 7 in Sheet2
- Download the modified Excel file from Aspose Cloud storage and save it locally
These steps summarize how to unmerge cells without losing data using Java-based API. The code uploads an Excel file to Aspose Cloud, then unmerges a specified range of cells F6:H8 in “Sheet2” using the Aspose.Cells Cloud API. After unmerging, it downloads the updated file and saves it locally as output.xlsx.
Code to Split Merged Cells using Java RESTful Service
This sample code has demonstrated the process to split merged cells in Excel using Java REST API. You can automatically detect and unmerge all merged cells using the GetWorksheetMergedCells() method. Note that when you split merged cells, the content in the merged area is automatically copied to the top-left cell in the given range.
This article has taught us the process of splitting merged cells in an Excel file. To merge cells in an Excel file, refer to the article Merge cells in Excel using Java REST API.
