allRows method

Future<List<List<Cell>>> allRows({
  1. int fromRow = 1,
  2. int fromColumn = 1,
  3. int length = -1,
  4. int count = -1,
})

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),
  );
}