insertValue method
Updates cell's value to value.
Expands current sheet's size if inserting range is out of sheet's bounds.
row - row index to insert value to,
rows start at index 1
column - column index to insert value to,
columns start at index 1 (column A)
Returns Future true in case of success.
Throws GSheetsException.
Implementation
Future<bool> insertValue(
Object value, {
required int column,
required int row,
}) async {
checkIndex('column', column);
checkIndex('row', row);
return _ws._update(
values: [value],
range: await _ws._columnRange(column, row, 1),
majorDimension: dimenColumns,
);
}