class

XLSX::Sheet

Inherits Reference < Object

A single worksheet within a document.

Rows are stored sparsely: only rows present in the XML exist here. Row IDs are 1-based, matching Excel's row numbering.

Constructors

new(name : String, rows : Hash(Int32, Row))
Source

Instance methods

[](row_id : Int32, col_id : Int32) : CellValue

Returns the cell at (row_id, col_id), or nil if either is absent.

Source
each_row

Yields each present row and its 1-based row ID, in row order. Absent rows are skipped.

Source
empty?
Source
name
Source
row(row_id : Int32) : Row | Nil

Returns the Row at row_id, or nil if absent.

Source
row_count

Returns the number of present rows.

Source
row_span

Returns the range from the first to last present row ID. Raises Enumerable::EmptyError if the sheet has no rows.

Source