allRows method

Future<List<List<String>>> allRows({
  1. int fromRow = 1,
  2. int fromColumn = 1,
  3. int length = -1,
  4. int count = -1,
  5. bool fill = false,
})

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