insert method
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,
);
}