Search Text in Remote Excel Spreadsheets - Find Data in Specific Ranges

Programmatically search for specific text within any range of Excel spreadsheets using Aspose.Cells Cloud API. Find text, numbers, or formulas in remote files stored in cloud storage. RESTful API for automated data discovery, content analysis, and spreadsheet auditing workflows.

Search Content In Remote Range API

API Endpoint

PUT http://api.aspose.cloud/v4.0/cells/{name}/worksheets/{worksheet}/ranges/{cellArea}/search/content

Request Parameters:

Parameter Name Type Path/Query String/HTTPBody Description
name String Path Required. The filename (including extension) of the Excel workbook to search, e.g., customer_data.xlsx.
worksheet String Path Required. The exact name of the worksheet within the workbook to search in, e.g., Orders_2024.
cellArea String Path Required. The target cell range for the search, specified in A1 notation (e.g., B2:H100). The search is confined to this area.
searchText String Query Required. The specific text string, number, or partial content to find within the defined cell area.
ignoringCase Boolean Query Optional. When set to true, the search ignores case differences (e.g., “Report” matches “report”). Default is usually false (case-sensitive).
folder String Query Optional. The directory path in your cloud storage where the workbook is located. If omitted, the root directory is used.
storageName String Query Optional. The name identifier for a custom cloud storage configuration. If not specified, the default storage for the account is used.
region String Query Optional. The locale setting (e.g., en-AU) to apply, which may affect the interpretation of region-specific characters or formats during the search.
password String Query Optional. The password to decrypt and access a password-protected spreadsheet file. Omit if the file is not encrypted.

Response

{
  "Name": "BrokenLinksResponse",
  "Type": "Class",
  "ParentName": "CellsCloudResponse",
  "Properties": [
    {
      "Name": "BrokenLinks",
      "DataType": {
        "Identifier": "Container",
        "Reference": "BrokenLink",
        "ElementDataType": {
          "Identifier": "Class",
          "Reference": "BrokenLink",
        },
      }
    },
    {
      "Name": "Code",
      "DataType": {
        "Identifier": "Integer",
      }
    },
    {
      "Name": "Status",
      "DataType": {
        "Identifier": "String",
      }
    }
  ]
}

Error Codes

  • 400 Bad Request: Invalid Aspose.Cells Cloud API URI.
  • 401 Unauthorized: Invalid access token. Or invalid client id and secret.
  • 404 Not Found: The spreadsheet file not accessible.
  • 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.

Where should we use the Search content within the range of the Spreadsheet API?

  • Large-scale Data Quality Check: During the acceptance stage of the data warehouse ETL process, search for missing field descriptions, undefined abbreviations or placeholder text (such as "TBD" or "NULL") in the data mapping table (such as DataDictionary!B2:F1000) to identify incomplete data definitions.
  • Dynamic Report Generation and Content Extraction: In the automated reporting system, intelligently search and extract the current period data blocks marked with specific identifiers (such as "[KPI]") from the template worksheet containing mixed data (such as Monthly_Metrics!C10:G50), for assembling the final report.
  • Contract and Legal Document Analysis: When the legal team reviews the electronic spreadsheet appendix containing a large number of clauses, efficiently search for specific legal terms (such as "liability limit") or contract party names or dates within the specified range (such as Contract_Terms!A column), to accelerate the review process.

Why should you use the Search content within the range of the Spreadsheet API?

  • Developer-Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared to building custom chart rendering solutions, this significantly reduces the development workload.
  • Reduced Labor Costs: Reduced the need for positions dedicated to document consolidation.
  • Pay-per-use: No upfront investment, only pay for API calls actually used.
  • Zero Maintenance Costs: No need to maintain servers, update software, or deal with compatibility issues.
  • Preserves complex Excel formatting in universally accessible PDF format.

OpenAPI Specification

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

Use Aspose.Cells Cloud SDKs

Using the SDK is the best way to accelerate development. The SDK handles the underlying details, allowing you to simply implement search content within range of spreadsheets for cells with minimal code. Please check out the GitHub repository 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: