Get Row Description from an Excel Worksheet – Aspose.Cells Cloud API

Prerequisites:

Obtain a valid JWT access token and include it in the Authorization: Bearer <jwt token> header.
Ensure the workbook is stored in Aspose Cloud storage or specify the folder path where it resides.
Use API version v3.0 as shown in the endpoint URL.

This REST API retrieves row data by its index on an Excel worksheet.

GetWorksheetRow API

GET https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex}

Security and Authentication

The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.

Request parameters

Parameter Name	Type	Location	Description
name	string	path	The name of the workbook file.
sheetName	string	path	The name of the worksheet within the workbook.
rowIndex	integer	path	Zero-based index of the row to retrieve.
folder	string	query	The folder that contains the workbook.
storageName	string	query	The name of the storage where the workbook resides.

The OpenAPI Specification defines a publicly accessible programming interface and lets you perform 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. Include the Authorization: Bearer <jwt token> header to authenticate the request.

Request

curl -v "https://api.aspose.cloud/v3.0/cells/test.xlsx/worksheets/Sheet1/cells/rows/0" \
  -X GET \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "Authorization: Bearer <jwt token>"

Response

{
  "Row": {
    "GroupLevel": 0,
    "Height": 13.5,
    "Index": 0,
    "IsBlank": false,
    "IsHeightMatched": true,
    "IsHidden": false,
    "Style": {
      "link": {
        "Href": "/style",
        "Rel": "self"
      }
    },
    "link": {
      "Href": "https://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/cells/rows/0",
      "Rel": "self"
    }
  },
  "Code": 200,
  "Status": "OK"
}

Response schema

Property	Type	Description
`GroupLevel`	integer	Outline level of the row (used for grouping).
`Height`	number	Height of the row in points.
`Index`	integer	Zero‑based index of the row returned.
`IsBlank`	boolean	Indicates whether the row contains any data.
`IsHeightMatched`	boolean	`true` if the row height matches the default row height.
`IsHidden`	boolean	`true` if the row is hidden.
`Style`	object	Object containing style information for the row.
`link`	object	Hyperlink reference to the row resource.
`Code`	integer	HTTP status code of the response.
`Status`	string	Textual description of the status (e.g., “OK”).

Notes / Error handling: The API may return the following HTTP status codes:

200 – Success; the row data is returned.
401 – Unauthorized; the JWT token is missing or invalid.
404 – Not found; the specified workbook, worksheet, or row does not exist.
500 – Internal server error; an unexpected condition occurred.

Code	Description	Remediation
200	Success – row data returned.	–
401	Unauthorized – missing or invalid JWT token.	Provide a valid JWT token.
404	Not found – workbook, worksheet, or row missing.	Verify names and row index.
500	Internal server error – unexpected condition.	Contact Aspose support.

For a complete list of error codes, see the Aspose.Cells Cloud Error Codes documentation.

Cloud SDK Family

Using an SDK is the fastest way to develop. An SDK abstracts 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: