Working with Excel Ranges – Aspose.Cells Cloud Documentation
Contents
[
Hide
]
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
- Get Named Ranges inside the Workbook – Retrieves all named ranges defined in a workbook, returning their addresses and scope.
- Get Cells Data Based on Named Range – Returns the values of cells that belong to a specified named range.
- Change Heights of Rows inside the Range – Adjusts the height of each row that falls within the given range.
- Change Widths of Columns inside the Range – Modifies the column width for all columns intersecting the range.
- Combine a Range of Cells into a Single Cell – Merges the selected cells into one cell, preserving the top‑left value.
- Copy Range in a Worksheet with Paste Options – Copies a source range to a destination range with optional paste types (values, formats, formulas, etc.).
- Set the Style of the Range – Applies font, fill, border, and alignment styles to every cell in the range.
- Unmerge Merged Cells of the Range – Reverses a previous merge operation, restoring the original individual cells.
- Move a Named Range with an Excel Worksheet – Relocates a named range to a new address within the same worksheet or to another worksheet.
- Set Range Value in Excel Worksheet – Writes a single value or an array of values to the specified range.