appendRows method

Future<bool> appendRows(
  1. List<List> values, {
  2. int fromColumn = 1,
  3. bool inRange = false,
})

Appends rows.

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

values - values to insert (not null nor empty)

fromColumn - optional (defaults to 1), column index for the first inserted value of values, columns start at index 1 (column A)

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

Returns Future true in case of success.

Throws GSheetsException.

Implementation

Future<bool> appendRows(
  List<List<dynamic>> values, {
  int fromColumn = 1,
  bool inRange = false,
}) async {
  final rows = await allRows(fromColumn: inRange ? fromColumn : 1);
  return insertRows(rows.length + 1, values, fromColumn: fromColumn);
}