QueryCells Method
Queries a Google Worksheet Cells feed using the specified parameters.
Syntax
gspreadsheets.queryCells([callback])
Callback
The 'callback' parameter specifies a function which will be called when the operation completes (or an error is encountered). If the 'callback' parameter is not specified, then the method will block and will not return until the operation completes (or an error is encountered).
The callback for this method is defined as:
function(err){ }
'err' is the error that occurred. If there was no error, then 'err' is 'null'.
'err' has 2 properties which hold detailed information:
err.code err.message
Remarks
Queries a Google Worksheet Cells feed using the specified QueryParams. To fetch a Google Worksheet Cells feed, without filtering any of the cells, you can call QueryCells without adding any parameters to QueryParams.
The cell 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 class will then attempt to parse the Google Worksheet Cells feed. Upon successfully parsing the response, FeedProperties will be set with their associated feed element values. The CellList event will fire once for each cell and the following properties will also be populated (CellIndex is used to navigate the returned cells):
- CellETag
- CellDetails
- CellProperties