Refresh an Auto Filter in an Excel Worksheet
Contents
[
Hide
]
This REST API refreshes an auto‑filter on an Excel worksheet.
What does Refresh do?
Calling the endpoint re‑applies the current filter criteria after the worksheet data has changed (e.g., rows added or removed). The operation does not modify the filter definition; it simply updates the view and returns a status response.
REST API
POST https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/autoFilter/refresh
Request parameters
| Parameter Name | Type | Location | Description |
|---|---|---|---|
| name | string | path | Name of the Excel file (e.g., Book1.xlsx). |
| sheetName | string | path | Name of the worksheet that contains the filter. |
| folder | string | query | Folder path in storage where the file resides. |
| storageName | string | query | Name of the storage (if not the default). |
You can use the cURL command‑line tool to call the API easily. The example below demonstrates a request with a valid JWT token.
cURL request and response
Possible errors
| HTTP Status | Code | Description | Recommended action |
|---|---|---|---|
| 400 | BadRequest |
The request is malformed or required parameters are missing. | Verify all required path/query parameters. |
| 401 | Unauthorized |
Invalid or missing JWT token. | Obtain a fresh token and include it in the Authorization header. |
| 404 | NotFound |
The specified file or worksheet does not exist. | Check the name, sheetName, and folder values. |
| 500 | InternalServerError |
An unexpected server error occurred. | Retry later or contact Aspose support with the request ID. |
SDK examples
(The Cloud SDK Family section is unchanged.)
FAQ
How do I refresh an AutoFilter after adding new rows?
Call `POST /cells/{name}/worksheets/{sheetName}/autoFilter/refresh` with a valid JWT token. The endpoint re‑applies the existing filter criteria to the updated data range.What response do I get if the file does not exist?
The API returns **404** with the JSON body `{ "Code": 404, "Status": "File not found" }`.Can I refresh an AutoFilter on a workbook stored in a custom storage?
Yes. Include the `storageName` query parameter that points to the custom storage location.Additional information
- Supported version: Aspose.Cells Cloud v3.0 and later.
- Reference links:
- OpenAPI specification: https://apireference.aspose.cloud/cells/#/AutoFilter/PostWorksheetAutoFilterRefresh
- SDK documentation: https://docs.aspose.cloud/cells/sdk/
Authored by an Aspose Cloud Engineer (2024). For security details, see the Aspose Cloud security whitepaper.