allColumns method

Future<List<List<String>>> allColumns({
  1. int fromColumn = 1,
  2. int fromRow = 1,
  3. int length = -1,
  4. int count = -1,
  5. bool fill = false,
})

Fetches all columns.

Expands current sheet's size if requested range is out of sheet's bounds.

fromColumn - optional (defaults to 1), index of a first returned column (columns before fromColumn will be skipped), columns start at index 1 (column A)

fromRow - optional (defaults to 1), index of a row that columns start from (values before fromRow will be skipped), rows start at index 1

length - optional (defaults to -1), the length of requested columns if length is -1, all values starting from fromRow will be returned

count - optional (defaults to -1), the number of requested columns if count is -1, all columns starting from fromColumn will be returned

fill - optional (defaults to false), whether to fill with empty strings to columns if their length is shorter

Returns all columns as Future List of List.

Throws GSheetsException.

Implementation

Future<List<List<String>>> allColumns({
  int fromColumn = 1,
  int fromRow = 1,
  int length = -1,
  int count = -1,
  bool fill = false,
}) async {
  checkIndex('fromColumn', fromColumn);
  checkIndex('fromRow', fromRow);
  final range = await _ws._allColumnsRange(
    fromColumn,
    fromRow,
    length,
    count,
  );
  return _ws._getAll(range, dimenColumns, fill);
}