UpdateCell Method

Updates a cell within a Google Worksheet.

Syntax

[VB.NET]
Public Sub UpdateCell()

[C#]
public void UpdateCell();

Remarks

The component will update the cell, specified by CellIndex, within the worksheet specified by WorksheetIndex. The cell will be updated using the values contained within CellDetails.

To clear a cell, you can set InputValue to "" (empty string).

When performing an update, if the cell specified by CellIndex already contains data it will be overwritten with the new InputValue.

Prior to calling UpdateCell, you must specify a CellETag value so that an "If-Match" header is sent (note this property is set automatically when CellIndex is set). To ensure that you do not update a cell that has been changed, set CellETag to the cell's ETag value. Setting CellETag to "*", will update the cell regardless of whether it has been updated or not.

Upon a successful update, the response will be parsed and the below listed properties will be populated. Thus all previous cells contained by the component, prior to the UpdateCell call, will be cleared and replaced with the response cell data. OtherHeaders will also be cleared and thus will need to be reset accordingly with each call made.

• CellETag
• CellDetails
• CellProperties