Worksheet class

One sheet of a Workbook: its cells, layout, merges, links and notes.

Constructors

Worksheet({required String name, required List<List<SheetCell?>> rows, SheetVisibility visibility = SheetVisibility.visible, int frozenRows = 0, int frozenColumns = 0, SheetLayout layout = SheetLayout.standard, List<CellRange> merges = const [], Map<CellAddress, String> hyperlinks = const {}, Map<CellAddress, CellComment> comments = const {}, Set<UnshownContent> unshown = const {}})
Creates a sheet; everything but name and rows defaults to empty.
const

Properties

columnCount → int
Width of the widest row.
no setter
comments → Map<CellAddress, CellComment>
Notes (Excel's comments) by cell.
final
frozenColumns → int
Columns frozen at the left by the author (a frozen <pane>'s xSplit); 0 for none.
final
frozenRows → int
Rows frozen at the top by the author (a frozen <pane>'s ySplit); 0 for none.
final
hashCode → int
The hash code for this object.
no setterinherited
Link targets by cell: a URL, or a place in the workbook (#Sheet2!A1). A link over a range is set on every cell of it (up to a limit).
final
layout → SheetLayout
Column widths, row heights and what the author hid.
final
merges → List<CellRange>
Merged areas: each shows its top-left cell across the whole range.
final
name → String
The tab name, from <sheet name> (SheetN when the file has none).
final
rows → List<List<SheetCell?>>
Rows from the first (index 0 = row 1) to the last one holding a cell. Rows have different lengths: each stops at its own last cell, and a missing cell is null.
final
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
unshown → Set<UnshownContent>
What the sheet holds that is not drawn.
final
visibility → SheetVisibility
Whether the author hid the sheet.
final

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited