WorksheetAsValues class
Interactor for working with Worksheet cells as String values.
Methods
-
allColumns({int fromColumn = 1, int fromRow = 1, int length = -1, int count = -1, bool fill = false})
→ Future<List<List<String>>>
-
Fetches all columns.
-
allRows({int fromRow = 1, int fromColumn = 1, int length = -1, int count = -1, bool fill = false})
→ Future<List<List<String>>>
-
Fetches all rows.
-
appendColumn(List values, {int fromRow = 1, bool inRange = false})
→ Future<bool>
-
Appends column.
-
appendColumns(List<List> values, {int fromRow = 1, bool inRange = false})
→ Future<bool>
-
Appends columns.
-
appendRow(List values, {int fromColumn = 1, bool inRange = false})
→ Future<bool>
-
Appends row.
-
appendRows(List<List> values, {int fromColumn = 1, bool inRange = false})
→ Future<bool>
-
Appends rows.
-
column(int column, {int fromRow = 1, int length = -1})
→ Future<List<String>>
-
Fetches specified column.
-
columnByKey(Object key, {int fromRow = 2, int length = -1})
→ Future<List<String>?>
-
Fetches column by its name.
-
columnIndexOf(Object key, {bool add = false, int inRow = 1})
→ Future<int>
-
Returns index of a column with
key
value in inRow
.
-
insertColumn(int column, List values, {int fromRow = 1})
→ Future<bool>
-
Updates column values with
values
.
-
insertColumnByKey(Object key, List values, {int fromRow = 2, bool eager = true})
→ Future<bool>
-
Updates column by its name values with
values
.
-
insertColumns(int column, List<List> values, {int fromRow = 1})
→ Future<bool>
-
Updates columns with
values
.
-
insertRow(int row, List values, {int fromColumn = 1})
→ Future<bool>
-
Updates row values with
values
.
-
insertRowByKey(Object key, List values, {int fromColumn = 2, bool eager = true})
→ Future<bool>
-
Updates row by its name values with
values
.
-
insertRows(int row, List<List> values, {int fromColumn = 1})
→ Future<bool>
-
Updates rows with
values
.
-
insertValue(Object value, {required int column, required int row})
→ Future<bool>
-
Updates cell's value to
value
.
-
insertValueByKeys(Object value, {required Object columnKey, required Object rowKey, bool eager = true})
→ Future<bool>
-
Updates cell's value to
value
by names of its column and row.
-
lastColumn({int fromRow = 1, int length = -1, bool inRange = false})
→ Future<List<String>?>
-
Fetches last column.
-
lastRow({int fromColumn = 1, int length = -1, bool inRange = false})
→ Future<List<String>?>
-
Fetches last row.
-
noSuchMethod(Invocation invocation)
→ dynamic
-
Invoked when a nonexistent method or property is accessed.
inherited
-
row(int row, {int fromColumn = 1, int length = -1})
→ Future<List<String>>
-
Fetches specified row.
-
rowByKey(Object key, {int fromColumn = 2, int length = -1})
→ Future<List<String>?>
-
Fetches row by its name.
-
rowIndexOf(Object key, {bool add = false, dynamic inColumn = 1})
→ Future<int>
-
Returns index of a row with
key
value in inColumn
.
-
toString()
→ String
-
A string representation of this object.
inherited
-
value({required int column, required int row})
→ Future<String>
-
Fetches cell's value.
-
valueByKeys({required Object rowKey, required Object columnKey})
→ Future<String?>
-
Fetches cell's value by names of its column and row.