allColumns method
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);
}