Get All Worksheet Validations from an Excel Worksheet

Worksheet validations let you define rules that restrict the type or range of data that can be entered into cells. They are commonly used to enforce data integrity, such as limiting entries to a list of values, dates within a specific range, or numeric limits.

This REST API retrieves all worksheet validations on an Excel worksheet.

REST API

GET https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/validations

Request parameters

Parameter Name	Type	Location	Description
name	string	path	Name of the Excel document.
sheetName	string	path	Name of the worksheet.
folder	string	query	Folder path where the document is stored.
storageName	string	query	Name of the storage service.

Response status codes

Code	Description
200	Successful request – list of validations
401	Unauthorized – invalid or missing token
404	Not found – document or worksheet missing
500	Internal server error

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 Cloud web services easily. Prerequisite: you must include a valid JWT token in the Authorization header.

Request

curl -v "https://api.aspose.cloud/v3.0/cells/myWorkBook.xlsx/worksheets/Sheet1/validations" \
-X GET \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"

Response

{
  "validations": [
    {
      "name": "Validation1",
      "type": "WholeNumber",
      "operator": "Between",
      "formula1": "1",
      "formula2": "100",
      "showErrorMessage": true,
      "errorMessage": "Value must be between 1 and 100."
    },
    {
      "name": "Validation2",
      "type": "List",
      "formula1": "\"Option1,Option2,Option3\"",
      "showErrorMessage": true,
      "errorMessage": "Select a value from the list."
    }
  ]
}

Cloud SDK Family

Using an SDK is the best way to speed up development. An SDK handles low‑level details so you can 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 call Aspose.Cells web services using various SDKs: