lastRow method

Future<Map<String, String>?> lastRow({ int fromColumn = 1, int length = -1, int mapTo = 1, bool inRange = false, })

Fetches last row, maps it to other row and returns map.

Expands current sheet's size if requested range is out of sheet's bounds.

fromColumn - optional (defaults to 1), index of a column that requested row starts from (values before fromColumn will be skipped), columns start at index 1 (column A)

length - optional (defaults to -1), the length of a requested row if length is -1, all values starting from fromColumn will be returned

mapTo - optional (defaults to 1), index of a row to map values to (keys of returned map), rows start at index 1

inRange - optional (defaults to false), whether should be fetched last row in range (respects fromColumn and length) or last row in table

Returns row as Future Map of String to String. Returns Future null if there are less than 2 rows.

Throws GSheetsException.

Implementation

Future<Map<String, String>?> lastRow({
  int fromColumn = 1,
  int length = -1,
  int mapTo = 1,
  bool inRange = false,
}) async {
  checkIndex('mapTo', mapTo);
  if (inRange) {
    final rows = await _values.allRows(
      fromColumn: fromColumn,
      length: length,
    );
    if (rows.length < 2) return null;
    checkMapTo(rows.length, mapTo);
    final row = rows.length;
    final keys = get(rows, at: mapTo - 1, or: <String>[])!;
    final values = get(rows, at: row - 1, or: <String>[])!;
    return _wrap(keys, values);
  } else {
    checkIndex('fromColumn', fromColumn);
    final rows = await _values.allRows();
    if (rows.length < 2) return null;
    checkMapTo(rows.length, mapTo);
    final row = rows.length;
    final keys = extractSublist(
      get(rows, at: mapTo - 1, or: <String>[])!,
      from: fromColumn - 1,
      length: length,
    );
    final values = extractSublist(
      get(rows, at: row - 1, or: <String>[])!,
      from: fromColumn - 1,
      length: length,
    );
    return _wrap(keys, values);
  }
}