Skip to content

Latest commit

 

History

History
46 lines (33 loc) · 1.94 KB

RemoveDuplicates.md

File metadata and controls

46 lines (33 loc) · 1.94 KB

Spreadsheet Cloud API: removeDuplicates

Removes duplicate values in the worksheet/range/table.

Quick Start

  • Base URL: http://api.aspose.cloud/v4.0
  • Authentication Method: JWT (OAuth2, application) Token URL: https://api.aspose.cloud/connect/token

Interface Details

Endpoint

PUT http://api.aspose.cloud/v4.0/cells/remove/duplicates

Function Description

This method scans the target scope for rows with identical values in the specified columnsToCheck.For each set of duplicates, all but the first occurrence are removed. The comparison is typically case-sensitive and matches the exact cell value.## Error Handling- 400 Bad Request: Invalid url.- 401 Unauthorized: Authentication has failed, or no credentials were provided.- 404 Not Found: Source file not accessible.- 500 Server Error The spreadsheet has encountered an anomaly in obtaining data.

The request parameters of removeDuplicates API are:

Parameter Name Type Path/Query String/HTTPBody Description
Spreadsheet File FormData Upload spreadsheet file.
worksheet String Query The worksheet name.
range String Query Range name that need deduplication.
table String Query Table name that need deduplication.
outPath String Query (Optional) The folder path where the workbook is stored. The default is null.
outStorageName String Query Output file Storage Name.
region String Query The spreadsheet region setting.
password String Query The password for opening spreadsheet file.

Response Description

{
File
}

OpenAPI Specification

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

[Back to API list]
[Back to README]