insertColumns method

Future<bool> insertColumns(
  1. int column,
  2. List<List> values, {
  3. int fromRow = 1,
})

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