insertColumns method
Updates columns with values
.
Expands current sheet's size if inserting range is out of sheet's bounds.
values
- values to insert (not null nor empty)
column
- column index to insert values
to,
columns start at index 1 (column A)
fromRow
- optional (defaults to 1), row index for the first inserted
value of values
, rows start at index 1
Returns Future true
in case of success.
Throws GSheetsException.
Implementation
Future<bool> insertColumns(
int column,
List<List<dynamic>> values, {
int fromRow = 1,
}) async {
checkIndex('column', column);
checkIndex('fromRow', fromRow);
checkValues(values);
return _ws._updateAll(
values: values,
range: await _ws._allColumnsRange(column, fromRow, -1, values.length),
majorDimension: dimenColumns,
);
}