Get cells data based on named range

This REST API returns a list of cells within a range identified by a named range or by row‑column indexes.

REST API

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

The request parameters are:

Parameter Name Type Location Description
name string path The workbook file name.
sheetName string path The worksheet name within the workbook.
namerange string query The named range to retrieve, e.g., A1:B2 or range_name1.
firstRow integer query Zero‑based index of the first row of the range (used when namerange is not supplied).
firstColumn integer query Zero‑based index of the first column of the range (used when namerange is not supplied).
rowCount integer query Number of rows to include in the range.
columnCount integer query Number of columns to include in the range.
folder string query The folder that contains the workbook.
storageName string query The name of the cloud storage where the workbook resides.

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

You can use the cURL command‑line tool to call Aspose.Cells web services easily. The example below demonstrates how to request cell values from a named range.

Cloud SDK Family

Using an SDK is the most efficient way to accelerate development. An SDK abstracts low‑level details, allowing you to focus on business logic. See 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:

Get Named Ranges on an Excel workbook