SpreadsheetList Event

Fired once for each spreadsheet entry retrieved.

Syntax

[VB.NET]
Public Event OnSpreadsheetList As OnSpreadsheetListHandler

[C#]
public event OnSpreadsheetListHandler OnSpreadsheetList;

public delegate void OnSpreadsheetListHandler(object sender, GspreadsheetsSpreadsheetListEventArgs e);

class GspreadsheetsSpreadsheetListEventArgs : EventArgs {
  string Id {get;}
  string ETag {get;}
  string DateUpdated {get;}
  string Title {get;}
  string Author {get;}
}

Remarks

The SpreadsheetList event is fired for each spreadsheet entry retrieved after a QuerySpreadsheets call.

Id contains the ID value for the current spreadsheet.

ETag contains the ETag value for the current spreadsheet.

DateUpdated contains the date and time that the current spreadsheet 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).

Title contains the title of the current spreadsheet.

Author contains the author of the current spreadsheet which by default is in the form: Name <e-mail address>. NameAndEmailFormat can be set to control the value displayed within SpreadsheetAuthor.