QueryRows Method

Queries a Google Worksheet Rows feed using the specified parameters.

Syntax

[VB.NET]
Public Sub QueryRows()

[C#]
public void QueryRows();

Remarks

Queries a Google Worksheet Rows feed using the specified QueryParams. To fetch a Google Worksheet Rows feed, without filtering any of the rows, you can call QueryRows without adding any parameters to QueryParams.

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.

The Google Worksheet Rows feed contains all rows after the first (header) row up to the first blank row. Thus the first blank row terminates the data set. For example, if the second row of the spreadsheet is blank, then the list feed will contain no data.

The row contents are delivered through the Transfer event. The response headers can be retrieved via the ParsedHeaders property as well as through the Header event.

The component will then attempt to parse the Google Worksheet Rows feed. Upon successfully parsing the response, FeedProperties will be set with their associated feed element values. The RowList event will fire once for each row and the following properties will also be populated (RowIndex is used to navigate the returned rows):

• RowETag
• RowDetails
• RowProperties