Worksheet class
One sheet of a Workbook: its cells, layout, merges, links and notes.
Constructors
-
Worksheet({required String name, required List<
List< rows, SheetVisibility visibility = SheetVisibility.visible, int frozenRows = 0, int frozenColumns = 0, SheetLayout layout = SheetLayout.standard, List<SheetCell?> >CellRange> merges = const [], Map<CellAddress, String> hyperlinks = const {}, Map<CellAddress, CellComment> comments = const {}, Set<UnshownContent> unshown = const {}}) -
Creates a sheet; everything but
nameandrowsdefaults 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>'sxSplit); 0 for none.final - frozenRows → int
-
Rows frozen at the top by the author (a frozen
<pane>'sySplit); 0 for none.final - hashCode → int
-
The hash code for this object.
no setterinherited
-
hyperlinks
→ Map<
CellAddress, String> -
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>(SheetNwhen 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