|
Moodle
2.2.1
http://www.collinsharper.com
|


Public Member Functions | |
| __construct ($client=null, $applicationId= 'MyCompany-MyApp-1.0') | |
| getSpreadsheetFeed ($location=null) | |
| getSpreadsheetEntry ($location) | |
| getWorksheetFeed ($location) | |
| GetWorksheetEntry ($location) | |
| getCellFeed ($location) | |
| getCellEntry ($location) | |
| getListFeed ($location) | |
| getListEntry ($location) | |
| updateCell ($row, $col, $inputValue, $key, $wkshtId= 'default') | |
| insertRow ($rowData, $key, $wkshtId= 'default') | |
| updateRow ($entry, $newRowData) | |
| deleteRow ($entry) | |
| getSpreadsheetListFeedContents ($location) | |
| getSpreadsheetCellFeedContents ($location, $range=null, $empty=false) | |
| getSpreadsheets ($location=null) | |
Data Fields | |
| const | SPREADSHEETS_FEED_URI = 'http://spreadsheets.google.com/feeds/spreadsheets' |
| const | SPREADSHEETS_POST_URI = 'http://spreadsheets.google.com/feeds/spreadsheets/private/full' |
| const | WORKSHEETS_FEED_LINK_URI = 'http://schemas.google.com/spreadsheets/2006#worksheetsfeed' |
| const | LIST_FEED_LINK_URI = 'http://schemas.google.com/spreadsheets/2006#listfeed' |
| const | CELL_FEED_LINK_URI = 'http://schemas.google.com/spreadsheets/2006#cellsfeed' |
| const | AUTH_SERVICE_NAME = 'wise' |
Static Public Attributes | |
| static | $namespaces |
Definition at line 95 of file Spreadsheets.php.
| __construct | ( | $ | client = null, |
| $ | applicationId = 'MyCompany-MyApp-1.0' |
||
| ) |
Create Gdata_Spreadsheets object
| Zend_Http_Client | $client | (optional) The HTTP client to use when when communicating with the Google servers. |
| string | $applicationId | The identity of the app in the form of Company-AppName-Version |
Reimplemented from Zend_Gdata.
Definition at line 122 of file Spreadsheets.php.

| deleteRow | ( | $ | entry | ) |
Deletes an existing row .
| ListEntry | $entry | The row to delete |
Definition at line 363 of file Spreadsheets.php.
| getCellEntry | ( | $ | location | ) |
Gets a cell entry.
| string | $location | A CellQuery or a URI specifying the entry location. |
Definition at line 239 of file Spreadsheets.php.


| getCellFeed | ( | $ | location | ) |
Gets a cell feed.
| string | $location | A CellQuery, WorksheetEntry or a URI specifying the feed location. |
Definition at line 221 of file Spreadsheets.php.


| getListEntry | ( | $ | location | ) |
Gets a list entry.
| string | $location | A ListQuery or a URI specifying the entry location. |
Definition at line 275 of file Spreadsheets.php.

| getListFeed | ( | $ | location | ) |
Gets a list feed.
| mixed | $location | A ListQuery, WorksheetEntry or string URI specifying the feed location. |
Definition at line 256 of file Spreadsheets.php.


| getSpreadsheetCellFeedContents | ( | $ | location, |
| $ | range = null, |
||
| $ | empty = false |
||
| ) |
Returns the content of all cells as an associative array, indexed off the cell location (ie 'A1', 'D4', etc). Each element of the array is an associative array with a 'value' and a 'function'. Only non-empty cells are returned by default. 'range' is the value of the 'range' query parameter specified at: http://code.google.com/apis/spreadsheets/reference.html#cells_Parameters
| mixed | $location | A CellQuery, WorksheetEntry or a URL (w/o query string) specifying the feed location. |
| string | $range | The range of cells to retrieve |
| boolean | $empty | Whether to retrieve empty cells |
Definition at line 403 of file Spreadsheets.php.

| getSpreadsheetEntry | ( | $ | location | ) |
Gets a spreadsheet entry.
| string | $location | A DocumentQuery or a URI specifying the entry location. |
Definition at line 159 of file Spreadsheets.php.

| getSpreadsheetFeed | ( | $ | location = null | ) |
Gets a spreadsheet feed.
| mixed | $location | A DocumentQuery or a string URI specifying the feed location. |
Definition at line 137 of file Spreadsheets.php.


| getSpreadsheetListFeedContents | ( | $ | location | ) |
Returns the content of all rows as an associative array
| mixed | $location | A ListQuery or string URI specifying the feed location. |
Definition at line 374 of file Spreadsheets.php.

| getSpreadsheets | ( | $ | location = null | ) |
Alias for getSpreadsheetFeed
| mixed | $location | A DocumentQuery or a string URI specifying the feed location. |
Definition at line 440 of file Spreadsheets.php.

| GetWorksheetEntry | ( | $ | location | ) |
Gets a worksheet entry.
| string | $location | A DocumentQuery or a URI specifying the entry location. |
Definition at line 201 of file Spreadsheets.php.

| getWorksheetFeed | ( | $ | location | ) |
Gets a worksheet feed.
| mixed | $location | A DocumentQuery, SpreadsheetEntry, or a string URI |
Definition at line 179 of file Spreadsheets.php.

Inserts a new row with provided data.
| array | $rowData | An array of column header to row data |
| string | $key | The key of the spreadsheet to modify |
| string | $wkshtId | (optional) The worksheet to modify |
Definition at line 319 of file Spreadsheets.php.

| updateCell | ( | $ | row, |
| $ | col, | ||
| $ | inputValue, | ||
| $ | key, | ||
| $ | wkshtId = 'default' |
||
| ) |
Updates an existing cell.
| int | $row | The row containing the cell to update |
| int | $col | The column containing the cell to update |
| int | $inputValue | The new value for the cell |
| string | $key | The key for the spreadsheet to be updated |
| string | $wkshtId | (optional) The worksheet to be updated |
Definition at line 296 of file Spreadsheets.php.

| updateRow | ( | $ | entry, |
| $ | newRowData | ||
| ) |
Updates an existing row with provided data.
| ListEntry | $entry | The row entry to update |
| array | $newRowData | An array of column header to row data |
Definition at line 345 of file Spreadsheets.php.
$namespaces [static] |
array( array('gs', 'http://schemas.google.com/spreadsheets/2006', 1, 0), array( 'gsx', 'http://schemas.google.com/spreadsheets/2006/extended', 1, 0) )
Reimplemented from Zend_Gdata.
Definition at line 109 of file Spreadsheets.php.
| const AUTH_SERVICE_NAME = 'wise' |
Reimplemented from Zend_Gdata.
Definition at line 102 of file Spreadsheets.php.
| const CELL_FEED_LINK_URI = 'http://schemas.google.com/spreadsheets/2006#cellsfeed' |
Definition at line 101 of file Spreadsheets.php.
| const LIST_FEED_LINK_URI = 'http://schemas.google.com/spreadsheets/2006#listfeed' |
Definition at line 100 of file Spreadsheets.php.
| const SPREADSHEETS_FEED_URI = 'http://spreadsheets.google.com/feeds/spreadsheets' |
Definition at line 97 of file Spreadsheets.php.
| const SPREADSHEETS_POST_URI = 'http://spreadsheets.google.com/feeds/spreadsheets/private/full' |
Definition at line 98 of file Spreadsheets.php.
| const WORKSHEETS_FEED_LINK_URI = 'http://schemas.google.com/spreadsheets/2006#worksheetsfeed' |
Definition at line 99 of file Spreadsheets.php.