Get Text Items from an Excel Worksheet

REST API

This REST API reads a worksheet’s text items in an Excel file.

https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{worksheet}/textItems

Security and Authentication

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

Request Parameters

Parameter Name Type Location Required Description
name string path Yes Workbook file name.
sheetName string path Yes Name of the worksheet.
folder string query No Path to the folder that contains the workbook.
storageName string query No Name of the Aspose Cloud storage.

Response

{
  "Status":"OK",
  "Code":200,
  "TextItems": {
    "link": {
      "Href": "string",
      "Rel": "string",
      "Title": "string",
      "Type": "string"
    },
    "TextItemList": [
      {
        "link": {
          "Href": "string",
          "Rel": "string",
          "Title": "string",
          "Type": "string"
        },
        "Text": "string"
      }
    ]
  }
}

Response Status Codes

Code Meaning Description
200 OK Compression succeeded; response contains compressed file details.
400 Bad Request Missing or invalid parameters (e.g., unsupported file type).
401 Unauthorized Invalid or missing JWT token.
413 Payload Too Large Uploaded file exceeds size limit.
500 Internal Server Error Unexpected server error.

How to Use the GetWorksheetTextItems API with SDKs

GetWorksheetTextItems API Specification

The OpenAPI Specification{:target="_blank" rel=“noopener noreferrer”} 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.

Use Aspose.Cells Cloud SDKs

SDKs simplify integration by handling low‑level details and letting you focus on your project tasks. Please check out the GitHub repository{:target="_blank" rel=“noopener noreferrer”} for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to make calls to Aspose.Cells web services using various SDKs:

Get text items from an Excel workbook Find text in an Excel workbook