Copy Range in a Worksheet with Paste Options – Aspose.Cells Cloud API

This REST API copies a range in a worksheet of an Excel workbook. For related operations, see the Get Range and Update Range documentation.

Prerequisites: To use this endpoint you must have a valid OAuth 2.0 / JWT token and ensure your API version matches the request URL.

REST API

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

Request parameters

Parameter Name	Type	Location	Description
name	string	path	The name of the workbook.
sheetName	string	path	The name of the worksheet.
rangeOperate	string	body	The operation to perform: `copydata`, `copystyle`, `copyto`, or `copyvalue`.
folder	string	query	The folder that contains the workbook.
storageName	string	query	The name of the storage service.

Notes: The rangeOperate field determines what is copied. Use copydata to copy only cell values, copystyle for formatting, copyto for both data and style, and copyvalue to copy values without formulas. The API supports ranges up to 1 million cells; larger ranges may result in a timeout.

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

You can use the cURL command‑line tool to access Aspose.Cells web services easily. The following example shows how to make calls to the Cloud API with cURL.

Request

curl -v "https://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/ranges" \
  -X POST \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "Authorization: Bearer <jwt token>" \
  -d '{
        "Operate": "string",
        "Source": {
          "ColumnCount": 0,
          "ColumnWidth": 0,
          "FirstColumn": 0,
          "FirstRow": 0,
          "Name": "string",
          "RefersTo": "string",
          "RowCount": 0,
          "RowHeight": 0,
          "Worksheet": "string"
        },
        "Target": {
          "ColumnCount": 0,
          "ColumnWidth": 0,
          "FirstColumn": 0,
          "FirstRow": 0,
          "Name": "string",
          "RefersTo": "string",
          "RowCount": 0,
          "RowHeight": 0,
          "Worksheet": "string"
        },
        "PasteOptions": {
          "OnlyVisibleCells": true,
          "PasteType": "string",
          "SkipBlanks": true,
          "Transpose": true
        }
      }'

Response

{
  "Code": 200,
  "Status": "OK"
}

The successful response returns a 200 OK status. In case of an error, the API may return payloads such as:

{
  "Code": 400,
  "Message": "Bad Request – invalid parameters."
}

{
  "Code": 401,
  "Message": "Unauthorized – authentication token missing or invalid."
}

These error objects include an HTTP status code and a descriptive message to help diagnose issues.

You can download a sample workbook to test the copy operation here.

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 out 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: