CreateRow Method

Creates a new row within the specified Google Worksheet.

Syntax

[VB.NET]
Public Sub CreateRow()

[C#]
public void CreateRow();

Remarks

The component will create a new row within the worksheet specified by WorksheetIndex. The items contained within RowDetails will be used to create the new row.

The new row will be added immediately after the last row in the spreadsheet (which in the case of the Google Spreadsheets API is the row immediately before the first entirely blank row).

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 (Header) are used to locate the column (in the current row) in which a cell value is contained.

Upon a successful creation, the response will be parsed and the below listed properties will be populated with the returned values. Thus all previous rows contained by the component, prior to the CreateRow 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