Add a custom criteria in an Excel worksheet

This REST API filters a list using a custom criteria.

REST API

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

The request parameters are:

Parameter Name Type Location Description
name string path Name of the Excel file.
sheetName string path Name of the worksheet that contains the data to be filtered.
range string query Cell range that the filter will be applied to (e.g., A1:B1).
fieldIndex integer query Zero‑based index of the column on which the filter is applied.
operatorType1 string query First comparison operator (e.g., LessOrEqual, Equal).
criteria1 string query First filter value or expression.
isAnd boolean query If true, combines the two criteria with AND; otherwise OR.
operatorType2 string query Second comparison operator (optional).
criteria2 string query Second filter value or expression (optional).
matchBlanks boolean query When true, blanks are included in the filter results.
refresh boolean query If true, forces the worksheet to refresh after applying the filter.
folder string query Folder path in storage where the file is located.
storageName string query Name of the storage service.

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 a call to the Cloud API with cURL.

Cloud SDK Family

Using an SDK is the fastest way to develop. An SDK handles low‑level details so you can focus on your project logic. Please check out 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:

Add a filter in an Excel worksheet Delete a Date Filter