Copy rows on an Excel worksheet

This REST API copies rows within a worksheet.

REST API

POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/rows/copy

The request parameters are:

Parameter Name	Type	Location	Description
name	string	path	The workbook file name.
sheetName	string	path	The worksheet name.
sourceRowIndex	integer	query	Zero‑based index of the source row.
destinationRowIndex	integer	query	Zero‑based index where the rows will be placed.
rowNumber	integer	query	Number of rows to copy.
worksheet	string	query	(Optional) Worksheet identifier; usually same as sheetName.
folder	string	query	Path to the folder containing the document.
storageName	string	query	Name of the storage service.

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. The following example shows how to call the Cloud API with cURL.

Request

curl -v "https://api.aspose.cloud/v3.0/cells/test.xlsx/worksheets/Sheet1/cells/rows/copy?sourceRowIndex=1&destinationRowIndex=12&rowNumber=10" \
-X POST \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"

Response

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

Cloud SDK Family

Using an SDK is the fastest way to develop. An SDK abstracts low‑level details, allowing you to focus on your project logic. See 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:

Hide rows on an Excel worksheet