PHP Class Google\Spreadsheet\CellFeed

Author: Asim Liaquat ([email protected])
Mostra file Open project: asimlqt/php-google-spreadsheet-client Class Usage Examples

Protected Properties

Property Type Description
$entries array
$xml SimpleXMLElement The xml representation of the feed

Public Methods

Method Description
__construct ( SimpleXMLElement $xml ) Constructor
createCell ( integer $row, integer $col, string $value ) : CellEntry Create a entry to insert data
editCell ( integer $rowNum, integer $colNum, string $value ) : void Edit a single cell. the row and column indexing start at 1.
getBatchUrl ( ) : string
getCell ( integer $row, integer $col ) : CellEntry | null
getEntries ( ) : array Get the feed entries
getId ( ) : string Get the feed id. Returns the full url.
getPostUrl ( ) : string Get the feed post url
getXml ( ) : integer Get the raw XML
insertBatch ( BatchRequest $batchRequest ) : BatchResponse
toArray ( ) : array Returns the feed entries as a two-dimensional array, indexed by row/column number. Array may be sparse, if returned cell data is sparse.
updateBatch ( BatchRequest $batchRequest ) : BatchResponse

Method Details

__construct() public method

Constructor
public __construct ( SimpleXMLElement $xml )
$xml SimpleXMLElement

createCell() public method

Create a entry to insert data
public createCell ( integer $row, integer $col, string $value ) : CellEntry
$row integer
$col integer
$value string
return CellEntry

editCell() public method

So the first column of the first row will be (1,1).
public editCell ( integer $rowNum, integer $colNum, string $value ) : void
$rowNum integer Row number
$colNum integer Column number
$value string Can also be a formula
return void

getBatchUrl() public method

public getBatchUrl ( ) : string
return string

getCell() public method

public getCell ( integer $row, integer $col ) : CellEntry | null
$row integer
$col integer
return CellEntry | null

getEntries() public method

Get the feed entries
public getEntries ( ) : array
return array \Google\Spreadsheet\CellEntry

getId() public method

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

getPostUrl() public method

Get the feed post url
public getPostUrl ( ) : string
return string

getXml() public method

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

insertBatch() public method

public insertBatch ( BatchRequest $batchRequest ) : BatchResponse
$batchRequest Google\Spreadsheet\Batch\BatchRequest
return Google\Spreadsheet\Batch\BatchResponse

toArray() public method

Returns the feed entries as a two-dimensional array, indexed by row/column number. Array may be sparse, if returned cell data is sparse.
public toArray ( ) : array
return array

updateBatch() public method

public updateBatch ( BatchRequest $batchRequest ) : BatchResponse
$batchRequest Google\Spreadsheet\Batch\BatchRequest
return Google\Spreadsheet\Batch\BatchResponse

Property Details

$entries protected_oe property

protected array $entries
return array

$xml protected_oe property

The xml representation of the feed
protected SimpleXMLElement $xml
return SimpleXMLElement