Working with Excel Rows – Aspose.Cells Cloud API

Working with rows on an Excel file

Last updated: July 2026

Quick API reference for common row operations:

Operation HTTP Method Endpoint Key Parameters
Get Row GET /cells/{fileName}/worksheets/{sheetName}/rows/{rowIndex} fileName, sheetName, rowIndex
Add Row POST /cells/{fileName}/worksheets/{sheetName}/rows rowIndex, height
Copy Rows POST /cells/{fileName}/worksheets/{sheetName}/rows/copy sourceIndex, destinationIndex, rowCount
Delete Row DELETE /cells/{fileName}/worksheets/{sheetName}/rows/{rowIndex} fileName, sheetName, rowIndex
Hide Rows POST /cells/{fileName}/worksheets/{sheetName}/rows/hide startIndex, endIndex
Unhide Rows POST /cells/{fileName}/worksheets/{sheetName}/rows/unhide startIndex, endIndex
Group Rows POST /cells/{fileName}/worksheets/{sheetName}/rows/group startIndex, endIndex
Ungroup Rows POST /cells/{fileName}/worksheets/{sheetName}/rows/ungroup startIndex, endIndex

Request / Response details

  • Get Row
    Request: No body required.
    Response (200):

    {
  "RowIndex": 5,
  "Height": 15.0,
  "IsHidden": false,
  "Style": { ... }
}

    Errors: 400 Bad Request (invalid index), 404 Not Found (file or sheet missing).

  • Add Row
    Request body (JSON):

    {
  "RowIndex": 10,
  "Height": 20.0
}

    Response (201):

    { "Code": "Success", "Status": "Row added", "RowIndex": 10 }

    Errors: 400 Bad Request (missing/invalid parameters), 401 Unauthorized.

  • Copy Rows
    Request body (JSON):

    {
  "SourceIndex": 2,
  "DestinationIndex": 8,
  "RowCount": 3
}

    Response (200):

    { "Code": "Success", "Status": "Rows copied" }

    Errors: 400 Bad Request, 404 Not Found.

  • Delete Row
    Request: No body.
    Response (200):

    { "Code": "Success", "Status": "Row deleted", "RowIndex": 7 }

    Errors: 400 Bad Request, 404 Not Found.

  • Hide Rows
    Request body (JSON):

    { "StartIndex": 3, "EndIndex": 5 }

    Response (200): { "Code": "Success", "Status": "Rows hidden" }
    Errors: 400 Bad Request.

  • Unhide Rows – same payload as Hide Rows; response identical, status “Rows unhidden”.

  • Group Rows – same payload as Hide Rows; response status “Rows grouped”.

  • Ungroup Rows – same payload as Hide Rows; response status “Rows ungrouped”.

All operations require a valid OAuth 2.0/JWT access token and appropriate SDK version.