insert method

Future<bool> insert(List<Cell> values)

Updates cells with values of values.

values - cells with values to insert (not null nor empty)

Returns Future true in case of success.

Throws GSheetsException.

Implementation

Future<bool> insert(List<Cell> values) async {
  checkValues(values);
  except(
    !values.first._insertable,
    'Cells returned by findByValue, cell or cellByKeys cannot be inserted, '
    'use Cell\'s post method instead.',
  );
  final range =
      "'${values.first.worksheetTitle}'!${values.first.label}:${values.last.label}";
  final dimen =
      values.first.row == values.last.row ? dimenRows : dimenColumns;
  return _ws._update(
    values: values.map((cell) => cell.value).toList(),
    range: range,
    majorDimension: dimen,
  );
}