Match all non‑blank cells in an Excel worksheet

This REST API matches all non‑blank cells in the AutoFilter list on an Excel worksheet.

Prerequisites

A valid Aspose Cloud account.
A JWT token (see the Authentication section below).
The Excel file must be uploaded to Aspose Cloud storage before calling the API.

Authentication

The API requires a bearer token obtained via the Aspose Cloud OAuth flow.

Create an application in the Aspose Cloud portal.
Use the client ID and client secret to request a JWT token.
Include the token in the Authorization header of every request:

Authorization: Bearer <jwt token>

For detailed steps, refer to the [Authentication guide](https://docs.aspose.cloud/cells/authentication/).

REST API

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

Request Parameters

Parameter Name	Type	Location	Description
name	string	path	The name of the Excel file.
sheetName	string	path	The name of the worksheet that contains the AutoFilter.
fieldIndex	integer	query	Zero‑based index of the column to which the filter is applied.
folder	string	query	(Optional) Folder path where the file is stored.
storageName	string	query	(Optional) Name of the storage service to use.

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

Request

curl -v "http://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/autoFilter/matchNonBlanks?fieldIndex=0" \
  -X POST \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "Authorization: Bearer <jwt token>"

Response

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

Response Schema

Field	Type	Description
Code	integer	HTTP status code (e.g., `200`).
Status	string	Textual description of the result (`OK`).

Possible Error Responses

HTTP Code	Reason	Example Message
400	Bad Request	`Invalid fieldIndex parameter.`
401	Unauthorized	`Authentication failed. Invalid token.`
404	Not Found	`File or worksheet not found.`
500	Internal Server Error	`Unexpected error on the server.`

FAQ

Q: How do I match all non‑blank cells in an Excel worksheet using Aspose.Cells Cloud?
A: Send a POST request to /cells/{name}/worksheets/{sheetName}/autoFilter/matchNonBlanks with the required fieldIndex query parameter and a valid JWT token in the Authorization header.

Q: What are the required query parameters for the matchNonBlanks API?
A: fieldIndex (integer, required) – the zero‑based column index to filter. Optional parameters are folder and storageName.

Q: What is the expected response when the request succeeds?
A: A JSON object containing "Code": 200 and "Status": "OK" indicating that the filter was applied successfully.

Cloud SDK Family

Using an SDK is the best way to speed up development. An SDK handles low‑level details and lets you focus on your project tasks. 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:

Add Top 10 Filter to an Excel Worksheet (Aspose.Cells Cloud)