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.

HTTP Status Codes

Code	Meaning	Description
200	OK	Filter applied successfully; response contains operation details.
400	Bad Request	Missing or invalid parameters (e.g., unsupported file type).
401	Unauthorized	Invalid or missing JWT token.
413	Payload Too Large	Uploaded file exceeds size limit.
500	Internal Server Error	Unexpected server error.

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