Add date filter in an Excel worksheet

This REST API indicates to add a date filter on an Excel Worksheet.

RSET API


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

The request parameters are:

Parameter Name	Type	Path/Query String/HTTPBody	Description
name	string	Path	The workbook name.
sheetName	string	Path	The worksheet name.
range	string	Query
fieldIndex	integer	Query
dateTimeGroupingType	string	Query	Day/Hour/Minute/Month/Second/Year
year	integer	Query
month	integer	Query
day	integer	Query
hour	integer	Query
minute	integer	Query
second	integer	Query
matchBlanks	string	Query	true/false
refresh	string	Query	true/false
folder	string	Query	Original workbook folder.
storageName	string	Query	Storage name.

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

You can use cURL command-line tool to access Aspose.Cells web services easily. The following example shows how to make calls to Cloud API with cURL.

Request


curl -v "http://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/autoFilter/dateFilter?range=A1:B1&fieldIndex=0&dateTimeGroupingType=Year&year=1920&refresh=true" \
-X PUT \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"

Response

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

Cloud SDK Family

Using an SDK is the best way to speed up the development. An SDK takes care of 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 a filter in an Excel worksheet Delete a Date Filter