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