Spreadsheet Cloud API: getNamedRangeValue

Retrieve values in range.

Quick Start

• Base URL: http://api.aspose.cloud/v3.0
• Authentication Method: JWT (OAuth2, application) Token URL: https://api.aspose.cloud/connect/token
• Example

Interface Details

Endpoint

GET http://api.aspose.cloud/v3.0/cells/{name}/worksheets/ranges/{namerange}/value

Function Description

PageTitle: Retrieve values in range.PageDescription: Aspose.Cells Cloud provides robust support for obtaining values in range, a process known for its intricacy.HeadTitle: Retrieve values in range.HeadSummary: Aspose.Cells Cloud provides robust support for updating values in range, a process known for its intricacy.HeadContent: Aspose.Cells Cloud provides REST API which supports updating values in range and offers SDKs for multiple programming languages. These programming languages are include of Net, Java, Go, NodeJS, Python, and so on.

The request parameters of getNamedRangeValue API are:

| Parameter Name | Type | Path/Query String/HTTPBody | Description | | :- | :- | :- |:- | |name|String|Path|The file name.| |namerange|String|Path|Range name.| |folder|String|Query|The folder where the file is situated.| |storageName|String|Query|The storage name where the file is situated.|

Response Description

{
  "Name": "RangeValueResponse",
  "Description": [
    "Represents the RangeValue Response."
  ],
  "Type": "Class",
  "ParentName": "CellsCloudResponse",
  "IsAbstract": false,
  "Properties": [
    {
      "Name": "CellsList",
      "Description": [
        "Property Summary: Contains a list of elements labeled as \"Cell\"."
      ],
      "Nullable": true,
      "ReadOnly": false,
      "IsInherit": false,
      "DataType": {
        "Identifier": "Container",
        "Reference": "Cell",
        "ElementDataType": {
          "Identifier": "Class",
          "Reference": "Cell",
          "Name": "class:cell"
        },
        "Name": "container"
      }
    },
    {
      "Name": "Code",
      "Nullable": true,
      "ReadOnly": false,
      "IsInherit": true,
      "DataType": {
        "Identifier": "Integer",
        "Name": "integer"
      }
    },
    {
      "Name": "Status",
      "Nullable": true,
      "ReadOnly": false,
      "IsInherit": true,
      "DataType": {
        "Identifier": "String",
        "Name": "string"
      }
    }
  ]
}

OpenAPI Specification

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

[Back to API list]
[Back to README]