Zend Framework API Documentation » \Zend_Gdata_Spreadsheets

Methods
Properties

Constants
- SPREADSHEETS_CELL_FEED_URI
```
SPREADSHEETS_CELL_FEED_URI
```

Assists in constructing queries for Google Spreadsheets cells

Queries are not defined for APP, but are provided by Gdata services as an extension.

link	http://code.google.com/apis/gdata/spreadsheets/
category	Zend
package	Zend_Gdata
subpackage	Spreadsheets
copyright	Copyright (c) 2005-2015 Zend Technologies USA Inc. (http://www.zend.com)
license	New BSD License
inherited_from	\Zend_Gdata_Query

Methods

Constructs a new Zend_Gdata_Spreadsheets_CellQuery object.

__construct(string $url = null)

inherited_from	\Zend_Gdata_Query::__construct()

Parameters

$url

string

Base URL to use for queries

Create Gdata_Query object

__construct($url = null)

Inherited

Parameters

$url

__get()

__get($name)

Inherited

Parameters

$name

__set()

__set($name, $val)

Inherited

Parameters

$name

$val

getAlt()

getAlt() : string

Inherited

Returns

stringrss or atom

getAuthor()

getAuthor() : string

Inherited

Returns

stringauthor

getCategory()

getCategory()

Inherited

Gets the cell id for this query.

getCellId() : string

Returns

stringcell id

Gets the max-col attribute for this query.

getMaxCol() : string

Returns

stringmax-col

getMaxResults()

getMaxResults() : integer

Inherited

Returns

integermaxResults

Gets the max-row attribute for this query.

getMaxRow() : string

Returns

stringmax-row

Gets the min-col attribute for this query.

getMinCol() : string

Returns

stringmin-col

Gets the min-row attribute for this query.

getMinRow() : string

Returns

stringmin-row

getParam()

getParam(string $name)

Inherited

Parameters

$name

string

Gets the projection for this query.

getProjection() : string

Returns

stringprojection

getPublishedMax()

getPublishedMax() : string

Inherited

Returns

stringpublishedMax

getPublishedMin()

getPublishedMin() : string

Inherited

Returns

stringpublishedMin

getQuery()

getQuery() : string

Inherited

Returns

stringquery

Gets the attribute query string for this query.

getQueryString() : string

inherited_from	\Zend_Gdata_Query::getQueryString()

Returns

stringquery string

getQueryString()

getQueryString() : string

Inherited

Returns

stringquerystring

Gets the full query URL for this query.

getQueryUrl() : string

inherited_from	\Zend_Gdata_Query::getQueryUrl()

Returns

stringurl

getQueryUrl()

getQueryUrl() : string

Inherited

Returns

stringurl

Gets the range attribute for this query.

getRange() : string

Returns

stringrange

Gets the return-empty attribute for this query.

getReturnEmpty() : string

Returns

stringreturn-empty

Gets the spreadsheet key for this query.

getSpreadsheetKey() : string

Returns

stringspreadsheet key

getStartIndex()

getStartIndex() : integer

Inherited

Returns

integerstartIndex

getUpdatedMax()

getUpdatedMax() : string

Inherited

Returns

stringupdatedMax

getUpdatedMin()

getUpdatedMin() : string

Inherited

Returns

stringupdatedMin

Gets the visibility for this query.

getVisibility() : string

Returns

stringvisibility

Gets the worksheet id for this query.

getWorksheetId() : string

Returns

stringworksheet id

resetParameters()

resetParameters()

Inherited

setAlt()

setAlt(string $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

setAuthor()

setAuthor(string $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

setCategory()

setCategory(string $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

Sets the cell id for this query.

setCellId(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

Sets the max-col attribute for this query.

setMaxCol(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

setMaxResults()

setMaxResults(integer $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

integer

Returns

\Zend_Gdata_QueryProvides a fluent interface

Sets the max-row attribute for this query.

setMaxRow(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

Sets the min-col attribute for this query.

setMinCol(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

Sets the min-row attribute for this query.

setMinRow(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

setParam()

setParam(string $name, string $value) : \Zend_Gdata_Query

Inherited

Parameters

$name

string

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

Sets the projection for this query.

setProjection(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

setPublishedMax()

setPublishedMax(string $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

setPublishedMin()

setPublishedMin(string $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

setQuery()

setQuery(string $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

Sets the range attribute for this query.

setRange(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

Sets the return-empty attribute for this query.

setReturnEmpty(mixed $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

mixed

String or bool value for whether to return empty cells

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

Sets the spreadsheet key for this query.

setSpreadsheetKey(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

setStartIndex()

setStartIndex(integer $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

integer

Returns

\Zend_Gdata_QueryProvides a fluent interface

setUpdatedMax()

setUpdatedMax(string $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

setUpdatedMin()

setUpdatedMin(string $value) : \Zend_Gdata_Query

Inherited

Parameters

$value

string

Returns

\Zend_Gdata_QueryProvides a fluent interface

Sets the visibility for this query.

setVisibility($value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

Sets the worksheet id for this query.

setWorksheetId(string $value) : \Zend_Gdata_Spreadsheets_CellQuery

Parameters

$value

string

Returns

\Zend_Gdata_Spreadsheets_CellQueryProvides a fluent interface

Properties

Category for the query

$_category : string

Default

null

$_cellId

$_cellId

Default

null

Default URL

$_defaultFeedUri

Default

self::SPREADSHEETS_CELL_FEED_URI

inherited_from	\Zend_Gdata_Query::_defaultFeedUri

Default URL

$_defaultFeedUri : string

Default

null

Query parameters.

$_params : array

Default

array()

$_projection

$_projection

Default

'full'

$_spreadsheetKey

$_spreadsheetKey

Default

null

Base URL TODO: Add setters and getters

$_url : string

Default

null

$_visibility

$_visibility

Default

'private'

$_worksheetId

$_worksheetId

Default

'default'

Constants

SPREADSHEETS_CELL_FEED_URI

SPREADSHEETS_CELL_FEED_URI = 'https://spreadsheets.google.com/feeds/cells'