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 (values before fromColumn
will be skipped),
columns start at index 1 (column A)
length
- optional (defaults to -1), the length of requested rows
if length is -1
, all values 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
fill
- optional (defaults to false
), whether to fill with empty
strings to rows if their length is shorter
Returns all rows as Future List
of List
.
Throws GSheetsException.
Implementation
Future<List<List<String>>> allRows({
int fromRow = 1,
int fromColumn = 1,
int length = -1,
int count = -1,
bool fill = false,
}) async {
checkIndex('fromColumn', fromColumn);
checkIndex('fromRow', fromRow);
final range = await _ws._allRowsRange(
fromRow,
fromColumn,
length,
count,
);
return _ws._getAll(range, dimenRows, fill);
}