Remove Duplicate Rows from a ListObject – Aspose.Cells Cloud API Documentation

This REST API removes duplicate rows from a ListObject in an Excel worksheet.

REST API

POST https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex}/RemoveDuplicates

Request parameters

Parameter Name	Type	Location	Description
name	String	Path	The name of the Excel file.
sheetName	String	Path	The name of the worksheet that contains the list object.
listObjectIndex	Integer	Path	The zero‑based index of the list object to process.
folder	String	Query	(Optional) The folder path where the file is stored.
storageName	String	Query	(Optional) The name of the storage service.

Sample Request (cURL)

Request

curl -v "https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex}/RemoveDuplicates" \
  -X POST \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "Authorization: Bearer <jwt token>"

Response

{
  "Code": 200,
  "Status": "OK",
  "DuplicateRowsRemoved": 12,
  "Message": "Duplicate rows were successfully removed."
}

Response

On success the service returns a JSON object similar to the example above. The fields are:

Code – HTTP status code (200 for success).
Status – Textual description of the status.
DuplicateRowsRemoved – Number of rows that were eliminated.
Message – Additional information about the operation.

Error Codes

HTTP Status	Meaning	When it occurs
400	Bad Request	Missing or invalid parameters.
401	Unauthorized	No token supplied or token is expired/invalid.
404	Not Found	Specified file, worksheet, or list object does not exist.
500	Internal Server Error	Unexpected server‑side failure.

Cloud SDK Family

Using an SDK is the best way to speed up development. An SDK handles low‑level details so you can focus on your project tasks. Please check the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to call Aspose.Cells web services using various SDKs:

Add a List Object (Table) to an Excel Worksheet Convert List Object to Range – Aspose.Cells Cloud API