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