Working with Excel Ranges – Aspose.Cells Cloud Documentation

A range represents a single cell, an entire row, a whole column, a contiguous block of cells, or a three‑dimensional (3‑D) range that spans multiple worksheets.

Working with ranges on an Excel file

The Aspose.Cells Cloud REST API provides dedicated endpoints for each range operation. The following list links to detailed usage examples and includes the corresponding HTTP method and endpoint for quick reference.

  • Get Named Ranges inside the Workbook – Retrieves all named ranges defined in a workbook, returning their addresses and scope. API: GET /cells/{fileName}/worksheets/{sheetName}/namedranges.
  • Get Cells Data Based on Named Range – Returns the values of cells that belong to a specified named range. API: GET /cells/{fileName}/worksheets/{sheetName}/namedranges/{rangeName}/cells.
  • Change Heights of Rows inside the Range – Adjusts the height of each row that falls within the given range. API: PUT /cells/{fileName}/worksheets/{sheetName}/ranges/{rangeName}/rows/height.
  • Change Widths of Columns inside the Range – Modifies the column width for all columns intersecting the range. API: PUT /cells/{fileName}/worksheets/{sheetName}/ranges/{rangeName}/columns/width.
  • Combine a Range of Cells into a Single Cell – Merges the selected cells into one cell, preserving the top‑left value. API: POST /cells/{fileName}/worksheets/{sheetName}/ranges/{rangeName}/merge.
  • Copy Range in a Worksheet with Paste Options – Copies a source range to a destination range with optional paste types (values, formats, formulas, etc.). API: POST /cells/{fileName}/worksheets/{sheetName}/ranges/{sourceRange}/copy?destCell={destRange}&pasteType={type}.
  • Set the Style of the Range – Applies font, fill, border, and alignment styles to every cell in the range. API: PUT /cells/{fileName}/worksheets/{sheetName}/ranges/{rangeName}/style.
  • Unmerge Merged Cells of the Range – Reverses a previous merge operation, restoring the original individual cells. API: POST /cells/{fileName}/worksheets/{sheetName}/ranges/{rangeName}/unmerge.
  • Move a Named Range with an Excel Worksheet – Relocates a named range to a new address within the same worksheet or to another worksheet. API: PUT /cells/{fileName}/worksheets/{sheetName}/namedranges/{rangeName}/move.
  • Set Range Value in Excel Worksheet – Writes a single value or an array of values to the specified range. API: PUT /cells/{fileName}/worksheets/{sheetName}/ranges/{rangeName}/value.

All requests and responses are in JSON format. Include the Authorization header with your access token for authentication.