Add Format Condition

This REST API adds a format condition to a worksheet.

REST API

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

Request parameters

Parameter Name Type Location Description
name string path The name of the Excel workbook.
sheetName string path The name of the worksheet that contains the range to be formatted.
index integer path The zero-based index of the format condition to add or replace.
cellArea string query The cell range (e.g., A1:C3) to which the condition applies.
type string query The type of condition (e.g., Expression, CellValue).
operatorType string query The operator for the condition (e.g., Between, Equal).
formula1 string query The first formula or value used by the condition.
formula2 string query The second formula or value (required for some operators such as Between).
folder string query The folder in storage where the workbook is located.
storageName string query The name of the storage service (e.g., Default).

Error Responses

HTTP Code Reason Example Body
400 Bad Request – missing or invalid parameters. { "Code":"400", "Message":"Invalid parameter value." }
401 Unauthorized – missing or invalid JWT token. { "Code":"401", "Message":"Access token is missing or invalid." }
404 Not Found – workbook or worksheet does not exist. { "Code":"404", "Message":"File not found." }
500 Internal Server Error – unexpected server failure. { "Code":"500", "Message":"An unexpected error occurred." }

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 to call the Aspose.Cells API. The example below shows a complete request, including an empty JSON body.

cURL Example

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:

Add Condition to Conditional Formatting Delete Conditional Formatting – Aspose.Cells Cloud API Reference