| Member |
Description |
| Create(ASheet, ARow1, ACol1, ARow2, ACol2) |
Builds a new worksheet-owned range and normalizes
reversed corners so Row1/Col1 are always
the upper-left coordinate |
| RefA1 |
Vracia the range reference as A1 text. Single-cell ranges return a single cell reference such as B2 |
| SaveAsHTML |
Options overloads accept TXLSXHtmlExportOptions for Title, WriteDocument, IncludeStyles, IncludeBOM, and TableClass. Set WriteDocument to False for a table fragment; set IncludeBOM to False when embedding output in an existing UTF-8 response. The same options are available for selected-range HTML export. Exported output preserves cell hyperlinks as <a> anchors and anchored images as inline data: image URIs when they fall inside the selected rectangle. Cell comments inside the selected rectangle are also emitted as escaped <td> title attributes. When IncludeStyles is enabled, explicit ColWidth values are emitted as <col> widths and explicit RowHeight values as <tr> height styles. Rich-text cell runs are emitted as escaped <span> elements with inline font, color, emphasis, and underline styles when IncludeStyles is enabled. Cell borders are emitted as CSS border-left, border-right, border-top, and border-bottom rules when IncludeStyles is enabled. Hidden rows and columns marked by RowHidden / ColHidden, plus explicit zero-width columns, are skipped in the generated table and <colgroup>. Vertical alignment settings are emitted as CSS vertical-align rules when IncludeStyles is enabled |
| SetValue / SetFormula |
Writes the same value or formula text to every cell in the range through the worksheet cell collection |
| SetArrayFormula |
Sets a multi-cell CSE array formula over the range. The top-left cell stores the formula text and anchors the spill range, while the remaining cells point back to that root so each cell evaluates its own element of the matrix result. Pass formula text without the surrounding braces |
| ClearValues / Clear / ClearAll |
ClearValues and Clear remove values and formulas while preserving style indexes. ClearAll also clears style indexes |
| SetFontIndex / SetFillIndex / SetBorderIndex / SetNumberFormatIndex / SetAlignmentIndex |
Applies 1-based workbook palette indexes to each cell in the range. Pass 0 to clear the corresponding per-cell index |
| SetNumberFormat |
Looks up or appends a number-format string in the workbook palette, then applies the resulting 1-based index to the range. An empty format clears the per-cell index |
| SetBorders |
Composes border edges over the range. TXLSXBorderEdgeKind accepts xlsxEdgeAll, xlsxEdgeOutline, xlsxEdgeInside, xlsxEdgeInsideHorizontal, xlsxEdgeInsideVertical, xlsxEdgeTop, xlsxEdgeBottom, xlsxEdgeLeft, xlsxEdgeRight, xlsxEdgeDiagonalUp, and xlsxEdgeDiagonalDown. Use outline and inside edge selectors to build table borders without replacing unrelated edge settings |
| SetLocked / SetFormulaHidden |
Applies cell-protection flags to every cell in the range by reusing the workbook protection-style pool |
| AutoFitColumns / AutoFitRows |
Forwards to the worksheet auto-fit helpers over the range's column or row bounds. Optional width and height limits are passed through to keep report layouts inside design bounds |
| Merge / Unmerge |
Merge and Merge(False) create one merged rectangle. Merge(True) creates one merged range per row, matching Excel's merge-across behavior. Unmerge removes an exact merged-range match |
| Offset / Resize |
Vracia another worksheet-owned range shifted from the current bounds or resized to the requested row and column count |
| Sort |
Sorts the rows inside this range by one key column
or by multiple key columns in priority order. ADescending
selects ascending or descending order per key; omitted entries default
to ascending. Blank values sort last |
| ApplyBuiltinStyle |
Applies the visible appearance of an Excel built-in
cell style to every cell in the range. The helper writes direct
formatting by adding the matching font and fill to the workbook pools
and assigning the resulting indexes to the cells |
| CopyTo / MoveTo |
Copies or moves the whole range to a destination
top-left cell. Values, formulas, rich-text payloads, style indexes,
comments, hyperlinks, and drawing anchors are forwarded through the
worksheet range-copy and range-move helpers |
| InsertRows / DeleteRows / InsertCols / DeleteCols |
Performs whole-row or whole-column insertion and
deletion over the range bounds. These helpers forward to the worksheet
row/column shift operations so formulas, references, filters, page
setup ranges, chart ranges, names, images, and chart anchors stay
aligned with the edited grid |
| ApplyFormatPatch |
Applies selective formatting styles from another source range to this range using TXLSXFormatParts flags |
| CopyToClipboard |
Copies the range values and styles to the Windows clipboard |
| SaveAsPDF |
Exports the cell range as a PDF file or stream using the in-process PDF rendering engine |
| SetDynamicArrayFormula |
Sets a dynamic array formula over the range, supporting Excel's dynamic spill behavior |