PHP Class Google\Spreadsheet\Worksheet

Author: Asim Liaquat ([email protected])
ファイルを表示 Open project: asimlqt/php-google-spreadsheet-client Class Usage Examples

Public Methods

Method Description
__construct ( SimpleXMLElement $xml ) Initializes the worksheet object.
delete ( ) : null Delete this worksheet
getCellFeed ( array $query = [] ) : CellFeed Get the cell feed of this worksheet
getCellFeedUrl ( ) : string Get the cell feed url
getColCount ( ) : integer Get the number of columns in the worksheet
getCsv ( ) : string Get csv data of this worksheet
getEditUrl ( ) : string Get the edit url of the worksheet
getExportCsvUrl ( ) : string Get the export csv url
getGid ( ) : integer Get the worksheet GID
getId ( ) : string Get the worksheet id. Returns the full url.
getListFeed ( array $query = [] ) : ListFeed Get the list feed of this worksheet
getListFeedUrl ( ) : string The url which is used to fetch the data of a worksheet as a list
getRowCount ( ) : integer Get the number of rows in the worksheet
getTitle ( ) : string Get the title of the worksheet
getUpdated ( ) : DateTime Get the updated date
getXml ( ) : integer Get the raw XML
update ( string $title = null, integer $colCount = null, integer $rowCount = null ) : void Update worksheet

Method Details

__construct() public method

Initializes the worksheet object.
public __construct ( SimpleXMLElement $xml )
$xml SimpleXMLElement

delete() public method

Delete this worksheet
public delete ( ) : null
return null

getCellFeed() public method

Get the cell feed of this worksheet
public getCellFeed ( array $query = [] ) : CellFeed
$query array
return CellFeed

getCellFeedUrl() public method

Get the cell feed url
public getCellFeedUrl ( ) : string
return string

getColCount() public method

Get the number of columns in the worksheet
public getColCount ( ) : integer
return integer

getCsv() public method

Get csv data of this worksheet
public getCsv ( ) : string
return string

getEditUrl() public method

Get the edit url of the worksheet
public getEditUrl ( ) : string
return string

getExportCsvUrl() public method

Get the export csv url
public getExportCsvUrl ( ) : string
return string

getGid() public method

Get the worksheet GID
public getGid ( ) : integer
return integer

getId() public method

Get the worksheet id. Returns the full url.
public getId ( ) : string
return string

getListFeed() public method

Get the list feed of this worksheet
public getListFeed ( array $query = [] ) : ListFeed
$query array add additional query params to the url to sort/filter the results
return ListFeed

getListFeedUrl() public method

The url which is used to fetch the data of a worksheet as a list
public getListFeedUrl ( ) : string
return string

getRowCount() public method

Get the number of rows in the worksheet
public getRowCount ( ) : integer
return integer

getTitle() public method

Get the title of the worksheet
public getTitle ( ) : string
return string

getUpdated() public method

Get the updated date
public getUpdated ( ) : DateTime
return DateTime

getXml() public method

Get the raw XML
public getXml ( ) : integer
return integer

update() public method

Update worksheet
public update ( string $title = null, integer $colCount = null, integer $rowCount = null ) : void
$title string
$colCount integer
$rowCount integer
return void