appendColumns method

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

Appends columns.

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

values - values to insert (not null nor empty)

fromRow - optional (defaults to 1), row index for the first inserted value of values, rows start at index 1

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

Returns Future true in case of success.

Throws GSheetsException.

Implementation

Future<bool> appendColumns(
  List<List<dynamic>> values, {
  int fromRow = 1,
  bool inRange = false,
}) async {
  final columns = await allColumns(fromRow: inRange ? fromRow : 1);
  return insertColumns(columns.length + 1, values, fromRow: fromRow);
}