*/ class CellFeed { /** * The xml representation of the feed * * @var \SimpleXMLElement */ protected $xml; /** * * @var array */ protected $entries; /** * Constructor * * @param string $xml */ public function __construct($xml) { $this->xml = new SimpleXMLElement($xml); $this->entries = array(); } /** * Get the feed entries * * @return array \Google\Spreadsheet\CellEntry */ public function getEntries() { if(count($this->entries) > 0) { return $this->entries; } $postUrl = $this->getPostUrl(); foreach ($this->xml->entry as $entry) { $cell = new CellEntry($entry, $postUrl); $this->entries[$cell->getCellIdString()] = $cell; } return $this->entries; } /** * * @param type $row * @param type $col * * @return CellEntry|null */ public function getCell($row, $col) { if(count($this->entries) === 0) { $this->getEntries(); } $id = sprintf( "R%sC%s", $row, $col ); if(isset($this->entries[$id])) { return $this->entries[$id]; } return null; } /** * Edit a single cell. the row and column indexing start at 1. * So the first column of the first row will be (1,1). * * @param int $rowNum * @param int $colNum * @param string $value * * @return null */ public function editCell($rowNum, $colNum, $value) { $entry = sprintf(' ', $rowNum, $colNum, $value ); ServiceRequestFactory::getInstance()->post($this->getPostUrl(), $entry); } /** * * @param \Google\Spreadsheet\Batch\BatchRequest $batchRequest * * @return \Google\Spreadsheet\Batch\BatchResponse */ public function updateBatch(BatchRequest $batchRequest) { $xml = $batchRequest->createRequestXml($this); $response = ServiceRequestFactory::getInstance()->post($this->getBatchUrl(), $xml); return new BatchResponse(new SimpleXMLElement($response)); } /** * Get the feed post url * * @return string */ public function getPostUrl() { return Util::getLinkHref($this->xml, 'http://schemas.google.com/g/2005#post'); } /** * * @return string */ public function getBatchUrl() { return Util::getLinkHref($this->xml, 'http://schemas.google.com/g/2005#batch'); } }