RowList Event

Fired once for each row entry retrieved.

Syntax

[VB.NET]
Public Event OnRowList As OnRowListHandler

[C#]
public event OnRowListHandler OnRowList;

public delegate void OnRowListHandler(object sender, GspreadsheetsRowListEventArgs e);

class GspreadsheetsRowListEventArgs : EventArgs {
  string Id {get;}
  string ETag {get;}
  string DateUpdated {get;}
  string RowDetails {get;}
}

Remarks

The RowList event is fired for each row entry retrieved after a QueryRows call.

Id contains the ID value for the current row.

ETag contains the ETag value for the current row.

DateUpdated contains the date and time that the current worksheet was last updated. The format of the date will depend on the DateFormat you are currently using. Unless otherwise specified, the default format used is "yyyy-MM-ddTHH:mm:ss.fffZ" (e.g. 2011-04-04T18:44:20.000Z).

RowDetails contains the details about the current 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.

Therefore RowDetails will contain a comma-separated string of "[header]:[value]" pairs.