UpdateWorksheet Method

Updates a Google Worksheet.

Syntax

[VB.NET]
Public Sub UpdateWorksheet()

[C#]
public void UpdateWorksheet();

Remarks

The component will update the Google Worksheet specified by WorksheetIndex. It will update the worksheet with the values contained within the following properties:

• WorksheetTitle
• WorksheetRowCount
• WorksheetColumnCount

Note that updating WorksheetRowCount and WorksheetColumnCount to values that are less than their original values will delete the cells (and their contents) that do not exist within the new boundaries without warning.

To update the actual content of the worksheet, please refer to UpdateRow and UpdateCell.

When called an "If-Match" header will be sent with the value contained within WorksheetETag.

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

• WorksheetDateUpdated
• WorksheetETag
• WorksheetTitle
• WorksheetProperties