allRows method
Fetches all rows.
Expands current sheet's size if requested range is out of sheet's bounds.
fromRow
- optional (defaults to 1), index of a first returned row
(rows before fromRow
will be skipped),
rows start at index 1
fromColumn
- optional (defaults to 1), index of a column that rows start
from (cells before fromColumn
will be skipped),
columns start at index 1 (column A)
length
- optional (defaults to -1), the length of a requested rows
if length is -1
, all cells starting from fromColumn
will be returned
count
- optional (defaults to -1), the number of requested rows
if count is -1
, all rows starting from fromRow
will be returned
Returns all rows as Future List of List.
Throws GSheetsException.
Implementation
Future<List<List<Cell>>> allRows({
int fromRow = 1,
int fromColumn = 1,
int length = -1,
int count = -1,
}) async {
final rows = await _ws.values.allRows(
fromRow: fromRow,
fromColumn: fromColumn,
length: length,
count: count,
);
return List<List<Cell>>.generate(
rows.length,
(index) => _wrapRow(rows[index], fromRow + index, fromColumn),
);
}