java.lang.Object
- odata.msgraph.client.entity.Entity
- - odata.msgraph.client.entity.WorkbookRange

All Implemented Interfaces:

com.github.davidmoten.odata.client.ODataEntityType, com.github.davidmoten.odata.client.ODataType
```
public class WorkbookRange
extends Entity
implements com.github.davidmoten.odata.client.ODataEntityType
```

Nested Class Summary

Nested Classes
Modifier and Type Class Description

static class WorkbookRange.Builder

Field Summary

Fields
Modifier and Type	Field	Description
`protected String`	`address`
`protected String`	`addressLocal`
`protected Integer`	`cellCount`
`protected Integer`	`columnCount`
`protected Boolean`	`columnHidden`
`protected Integer`	`columnIndex`
`protected WorkbookRangeFormat`	`format`
`protected Json`	`formulas`
`protected Json`	`formulasLocal`
`protected Json`	`formulasR1C1`
`protected Boolean`	`hidden`
`protected Json`	`numberFormat`
`protected Integer`	`rowCount`
`protected Boolean`	`rowHidden`
`protected Integer`	`rowIndex`
`protected WorkbookRangeSort`	`sort`
`protected Json`	`text`
`protected Json`	`values`
`protected Json`	`valueTypes`
`protected WorkbookWorksheet`	`worksheet`

Fields inherited from class odata.msgraph.client.entity.Entity
changedFields, contextPath, id, odataType, unmappedFields

Constructor Summary

Constructors
Modifier Constructor Description

protected WorkbookRange()

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`boundingRect(String anotherRange)`
`static WorkbookRange.Builder`	`builderWorkbookRange()`	Returns a builder which is used to create a new instance of this class (given that this class is immutable).
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`cell(Integer row, Integer column)`
`com.github.davidmoten.odata.client.ActionRequestNoReturn`	`clear(String applyTo)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`column(Integer column)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`columnsAfter()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`columnsAfter_Function(Integer count)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`columnsBefore()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`columnsBefore_Function(Integer count)`
`com.github.davidmoten.odata.client.ActionRequestNoReturn`	`delete(String shift)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`entireColumn()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`entireRow()`
`Optional<String>`	`getAddress()`
`Optional<String>`	`getAddressLocal()`
`Optional<Integer>`	`getCellCount()`
`com.github.davidmoten.odata.client.internal.ChangedFields`	`getChangedFields()`
`Optional<Integer>`	`getColumnCount()`
`Optional<Boolean>`	`getColumnHidden()`
`Optional<Integer>`	`getColumnIndex()`
`WorkbookRangeFormatRequest`	`getFormat()`
`Optional<Json>`	`getFormulas()`
`Optional<Json>`	`getFormulasLocal()`
`Optional<Json>`	`getFormulasR1C1()`
`Optional<Boolean>`	`getHidden()`
`Optional<Json>`	`getNumberFormat()`
`Optional<Integer>`	`getRowCount()`
`Optional<Boolean>`	`getRowHidden()`
`Optional<Integer>`	`getRowIndex()`
`WorkbookRangeSortRequest`	`getSort()`
`Optional<Json>`	`getText()`
`com.github.davidmoten.odata.client.UnmappedFields`	`getUnmappedFields()`
`Optional<Json>`	`getValues()`
`Optional<Json>`	`getValueTypes()`
`WorkbookWorksheetRequest`	`getWorksheet()`
`com.github.davidmoten.odata.client.ActionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`insert(String shift)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`intersection(String anotherRange)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`lastCell()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`lastColumn()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`lastRow()`
`com.github.davidmoten.odata.client.ActionRequestNoReturn`	`merge(Boolean across)`
`String`	`odataTypeName()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`offsetRange(Integer rowOffset, Integer columnOffset)`
`WorkbookRange`	`patch()`	Submits only changed fields for update and returns an immutable copy of `this` with changed fields reset.
`void`	`postInject(boolean addKeysToContextPath)`
`WorkbookRange`	`put()`	Submits all fields for update and returns an immutable copy of `this` with changed fields reset (they were ignored anyway).
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`resizedRange(Integer deltaRows, Integer deltaColumns)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`row(Integer row)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`rowsAbove()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`rowsAbove_Function(Integer count)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`rowsBelow()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`rowsBelow_Function(Integer count)`
`String`	`toString()`
`com.github.davidmoten.odata.client.ActionRequestNoReturn`	`unmerge()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`usedRange()`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange>`	`usedRange_Function(Boolean valuesOnly)`
`com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRangeView>`	`visibleView()`
`WorkbookRange`	`withAddress(String address)`
`WorkbookRange`	`withAddressLocal(String addressLocal)`
`WorkbookRange`	`withCellCount(Integer cellCount)`
`WorkbookRange`	`withColumnCount(Integer columnCount)`
`WorkbookRange`	`withColumnHidden(Boolean columnHidden)`
`WorkbookRange`	`withColumnIndex(Integer columnIndex)`
`WorkbookRange`	`withFormat(WorkbookRangeFormat format)`
`WorkbookRange`	`withFormulas(Json formulas)`
`WorkbookRange`	`withFormulasLocal(Json formulasLocal)`
`WorkbookRange`	`withFormulasR1C1(Json formulasR1C1)`
`WorkbookRange`	`withHidden(Boolean hidden)`
`WorkbookRange`	`withNumberFormat(Json numberFormat)`
`WorkbookRange`	`withRowCount(Integer rowCount)`
`WorkbookRange`	`withRowHidden(Boolean rowHidden)`
`WorkbookRange`	`withRowIndex(Integer rowIndex)`
`WorkbookRange`	`withSort(WorkbookRangeSort sort)`
`WorkbookRange`	`withText(Json text)`
`WorkbookRange`	`withUnmappedField(String name, Object value)`
`WorkbookRange`	`withValues(Json values)`
`WorkbookRange`	`withValueTypes(Json valueTypes)`
`WorkbookRange`	`withWorksheet(WorkbookWorksheet worksheet)`

Methods inherited from class odata.msgraph.client.entity.Entity
getId, withId

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

address
```
protected String address
```

addressLocal
```
protected String addressLocal
```

cellCount
```
protected Integer cellCount
```

columnCount
```
protected Integer columnCount
```

columnHidden
```
protected Boolean columnHidden
```

columnIndex
```
protected Integer columnIndex
```

formulas
```
protected Json formulas
```

formulasLocal
```
protected Json formulasLocal
```

formulasR1C1
```
protected Json formulasR1C1
```

hidden
```
protected Boolean hidden
```

numberFormat
```
protected Json numberFormat
```

rowCount
```
protected Integer rowCount
```

rowHidden
```
protected Boolean rowHidden
```

rowIndex
```
protected Integer rowIndex
```

text
```
protected Json text
```

values
```
protected Json values
```

valueTypes
```
protected Json valueTypes
```

format
```
protected WorkbookRangeFormat format
```

sort
```
protected WorkbookRangeSort sort
```

worksheet
```
protected WorkbookWorksheet worksheet
```

Constructor Detail
- WorkbookRange
```
protected WorkbookRange()
```

Method Detail

odataTypeName
```
public String odataTypeName()
```
Specified by:

odataTypeName in interface com.github.davidmoten.odata.client.ODataType

Overrides:

odataTypeName in class Entity

builderWorkbookRange
```
public static WorkbookRange.Builder builderWorkbookRange()
```
Returns a builder which is used to create a new instance of this class (given that this class is immutable).

Returns:

a new Builder for this class

getChangedFields
```
public com.github.davidmoten.odata.client.internal.ChangedFields getChangedFields()
```
Specified by:

getChangedFields in interface com.github.davidmoten.odata.client.ODataEntityType

Overrides:

getChangedFields in class Entity

postInject
```
public void postInject(boolean addKeysToContextPath)
```
Specified by:

postInject in interface com.github.davidmoten.odata.client.ODataType

Overrides:

postInject in class Entity

getAddress
```
public Optional<String> getAddress()
```

withAddress

public WorkbookRange withAddress(String address)

getAddressLocal

public Optional<String> getAddressLocal()

withAddressLocal

public WorkbookRange withAddressLocal(String addressLocal)

getCellCount

public Optional<Integer> getCellCount()

withCellCount

public WorkbookRange withCellCount(Integer cellCount)

getColumnCount

public Optional<Integer> getColumnCount()

withColumnCount

public WorkbookRange withColumnCount(Integer columnCount)

getColumnHidden

public Optional<Boolean> getColumnHidden()

withColumnHidden

public WorkbookRange withColumnHidden(Boolean columnHidden)

getColumnIndex

public Optional<Integer> getColumnIndex()

withColumnIndex

public WorkbookRange withColumnIndex(Integer columnIndex)

getFormulas
```
public Optional<Json> getFormulas()
```

withFormulas

public WorkbookRange withFormulas(Json formulas)

getFormulasLocal

public Optional<Json> getFormulasLocal()

withFormulasLocal

public WorkbookRange withFormulasLocal(Json formulasLocal)

getFormulasR1C1

public Optional<Json> getFormulasR1C1()

withFormulasR1C1

public WorkbookRange withFormulasR1C1(Json formulasR1C1)

getHidden
```
public Optional<Boolean> getHidden()
```

withHidden

public WorkbookRange withHidden(Boolean hidden)

getNumberFormat

public Optional<Json> getNumberFormat()

withNumberFormat

public WorkbookRange withNumberFormat(Json numberFormat)

getRowCount

public Optional<Integer> getRowCount()

withRowCount

public WorkbookRange withRowCount(Integer rowCount)

getRowHidden

public Optional<Boolean> getRowHidden()

withRowHidden

public WorkbookRange withRowHidden(Boolean rowHidden)

getRowIndex

public Optional<Integer> getRowIndex()

withRowIndex

public WorkbookRange withRowIndex(Integer rowIndex)

getText
```
public Optional<Json> getText()
```

withText

public WorkbookRange withText(Json text)

getValues
```
public Optional<Json> getValues()
```

withValues

public WorkbookRange withValues(Json values)

getValueTypes
```
public Optional<Json> getValueTypes()
```

withValueTypes

public WorkbookRange withValueTypes(Json valueTypes)

withUnmappedField

public WorkbookRange withUnmappedField(String name,
                                       Object value)

Overrides:: withUnmappedField in class Entity

getFormat

public WorkbookRangeFormatRequest getFormat()

getSort

public WorkbookRangeSortRequest getSort()

getWorksheet

public WorkbookWorksheetRequest getWorksheet()

withFormat

public WorkbookRange withFormat(WorkbookRangeFormat format)

withSort

public WorkbookRange withSort(WorkbookRangeSort sort)

withWorksheet

public WorkbookRange withWorksheet(WorkbookWorksheet worksheet)

getUnmappedFields
```
public com.github.davidmoten.odata.client.UnmappedFields getUnmappedFields()
```
Specified by:

getUnmappedFields in interface com.github.davidmoten.odata.client.ODataType

Overrides:

getUnmappedFields in class Entity

patch
```
public WorkbookRange patch()
```
Submits only changed fields for update and returns an immutable copy of this with changed fields reset.

Overrides:

patch in class Entity

Returns:

a copy of this with changed fields reset

Throws:

com.github.davidmoten.odata.client.ClientException - if HTTP response is not as expected

put
```
public WorkbookRange put()
```
Submits all fields for update and returns an immutable copy of this with changed fields reset (they were ignored anyway).

Overrides:

put in class Entity

Returns:

a copy of this with changed fields reset

Throws:

com.github.davidmoten.odata.client.ClientException - if HTTP response is not as expected

clear

public com.github.davidmoten.odata.client.ActionRequestNoReturn clear(String applyTo)

delete

public com.github.davidmoten.odata.client.ActionRequestNoReturn delete(String shift)

insert

public com.github.davidmoten.odata.client.ActionRequestReturningNonCollectionUnwrapped<WorkbookRange> insert(String shift)

merge

public com.github.davidmoten.odata.client.ActionRequestNoReturn merge(Boolean across)

unmerge

public com.github.davidmoten.odata.client.ActionRequestNoReturn unmerge()

boundingRect

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> boundingRect(String anotherRange)

cell

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> cell(Integer row,
                                                                                                             Integer column)

column

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> column(Integer column)

columnsAfter

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> columnsAfter()

columnsAfter_Function

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> columnsAfter_Function(Integer count)

columnsBefore

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> columnsBefore()

columnsBefore_Function

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> columnsBefore_Function(Integer count)

entireColumn

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> entireColumn()

entireRow

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> entireRow()

intersection

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> intersection(String anotherRange)

lastCell

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> lastCell()

lastColumn

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> lastColumn()

lastRow

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> lastRow()

offsetRange

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> offsetRange(Integer rowOffset,
                                                                                                                    Integer columnOffset)

resizedRange

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> resizedRange(Integer deltaRows,
                                                                                                                     Integer deltaColumns)

row

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> row(Integer row)

rowsAbove

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> rowsAbove()

rowsAbove_Function

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> rowsAbove_Function(Integer count)

rowsBelow

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> rowsBelow()

rowsBelow_Function

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> rowsBelow_Function(Integer count)

usedRange

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> usedRange()

usedRange_Function

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRange> usedRange_Function(Boolean valuesOnly)

visibleView

public com.github.davidmoten.odata.client.FunctionRequestReturningNonCollectionUnwrapped<WorkbookRangeView> visibleView()

toString
```
public String toString()
```
Overrides:

toString in class Entity

Class WorkbookRange

Nested Class Summary

Field Summary

Fields inherited from class odata.msgraph.client.entity.Entity

Constructor Summary

Method Summary

Methods inherited from class odata.msgraph.client.entity.Entity

Methods inherited from class java.lang.Object

Field Detail

address

addressLocal

cellCount

columnCount

columnHidden

columnIndex

formulas

formulasLocal

formulasR1C1

hidden

numberFormat

rowCount

rowHidden

rowIndex

text

values

valueTypes

format

sort

worksheet

Constructor Detail

WorkbookRange

Method Detail

odataTypeName

builderWorkbookRange

getChangedFields

postInject

getAddress

withAddress

getAddressLocal

withAddressLocal

getCellCount

withCellCount

getColumnCount

withColumnCount

getColumnHidden

withColumnHidden

getColumnIndex

withColumnIndex

getFormulas

withFormulas

getFormulasLocal

withFormulasLocal

getFormulasR1C1

withFormulasR1C1

getHidden

withHidden

getNumberFormat

withNumberFormat

getRowCount

withRowCount

getRowHidden

withRowHidden

getRowIndex

withRowIndex

getText

withText

getValues

withValues

getValueTypes

withValueTypes

withUnmappedField

getFormat

getSort

getWorksheet

withFormat

withSort

withWorksheet

getUnmappedFields

patch

put