Worksheet class
Representation of a Worksheet.
Properties
- cells ↔ WorksheetAsCells
-
Interactor for working with Worksheet cells as Cell objects.
getter/setter pair
- columnCount → int
-
Current count of available columns.
no setter
- hashCode → int
-
The hash code for this object.
no setterinherited
- id → int
-
final
- index → int
-
Current index of of the sheet.
no setter
- inputOption → String
-
final
- renderOption → String
-
final
- rowCount → int
-
Current count of available rows.
no setter
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- spreadsheetId → String
-
final
- title → String
-
Current title of of the sheet.
no setter
- values ↔ WorksheetAsValues
-
Interactor for working with Worksheet cells as String values.
getter/setter pair
Methods
-
add(
{int rows = 0, int columns = 0}) → Future< bool> - Expands Worksheet by adding new rows/columns to the end of the sheet.
-
clear(
) → Future< bool> - Clears the whole Worksheet.
-
clearColumn(
int column, {int fromRow = 1, int length = -1, int count = 1}) → Future< bool> - Clears specified column.
-
clearRow(
int row, {int fromColumn = 1, int length = -1, int count = 1}) → Future< bool> - Clears specified row.
-
copyTo(
String spreadsheetId) → Future< bool> - Copies this Worksheet to another spreadsheet (the name of the copy will be "Copy of title").
-
deleteColumn(
int column, {int count = 1}) → Future< bool> - Deletes columns from Worksheet.
-
deleteRow(
int row, {int count = 1}) → Future< bool> - Deletes rows from Worksheet.
-
insertColumn(
int column, {int count = 1, bool inheritFromBefore = false}) → Future< bool> - Inserts new columns to Worksheet.
-
insertRow(
int row, {int count = 1, bool inheritFromBefore = false}) → Future< bool> - Inserts new rows to Worksheet.
-
moveColumn(
{required int from, required int to, int count = 1}) → Future< bool> - Moves columns.
-
moveRow(
{required int from, required int to, int count = 1}) → Future< bool> - Moves rows.
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
toString(
) → String -
A string representation of this object.
override
-
updateTitle(
String title) → Future< bool> - Updates title of this Worksheet.
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited