UpdateRow Method

Updates a row within a Google Worksheet.

Syntax

Remarks

The component will update the row, specified by RowIndex, within the worksheet specified by WorksheetIndex. The row will be updated using the values contained within RowDetails.

Note that the Google Worksheet Rows feed makes assumptions about how the data is laid out on the worksheet. In particular, the feed treats the first row of the worksheet as a header row. Thus all contents in the first row should only contain column header values. When performing row based operations, these header values (RowDetailHeader) are used to locate the column (in the current row) in which a cell value is contained.

Therefore the first (header) row in a worksheet cannot be updated using UpdateRow. If you wish to update a header column value, you will need to use UpdateCell.

Prior to calling UpdateRow, you must specify a RowETag value so that an "If-Match" header is sent (note this property is set automatically when RowIndex is set). To ensure that you do not update a row that has been changed, set RowETag to the row's ETag value. Setting RowETag to "*", will update the row 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 rows contained by the component, prior to the UpdateRow call, will be cleared and replaced with the response row data. OtherHeaders will also be cleared and thus will need to be reset accordingly with each call made.

• RowETag
• RowDetails
• RowProperties