Set the Style of the Range

Introduction

This example demonstrates how to set the style of a range using the Aspose.Cells Cloud API in your applications. You can use our REST API with any language, such as .NET, Java, PHP, Ruby, Rails, Python, jQuery, and many more.

API Information

API	Type	Description	Resource Link
/cells/{name}/worksheets/{sheetName}/ranges/style	POST	Set the cell style of a named range	PostWorksheetCellsRangeStyle

cURL Example

Request

curl -X POST "https://api.aspose.cloud/v3.0/cells/test.xlsx/worksheets/Sheet1/ranges/style" \
     -H "accept: application/json" \
     -H "Content-Type: application/json" \
     -d '{
           "Range": {
               "ColumnCount": 2,
               "ColumnWidth": 0,
               "FirstColumn": 1,
               "FirstRow": 1,
               "Name": "string",
               "RefersTo": "string",
               "RowCount": 2,
               "RowHeight": 0,
               "Worksheet": "Sheet1"
           },
           "Style": {
               "Font": {
                   "DoubleSize": 1,
                   "IsBold": true,
                   "IsItalic": true,
                   "IsStrikeout": true,
                   "IsSubscript": true,
                   "IsSuperscript": true
               }
           }
         }'

Response

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

SDK Source

The Aspose.Cells Cloud SDKs can be downloaded from the following page: Available SDKs

SDK Examples

Set range value on an Excel worksheet