/** * Retrieve a particular cell * @param string $st_id Spreadsheet ID * @param string $wt_id Worksheet ID * @return Zend_Gdata_Spreadsheets_CellEntry $entry CellEntry object containing cell data */ public function getCell($st_id, $wt_id, $cell_id) { $query = new Zend_Gdata_Spreadsheets_CellQuery(); $query->setSpreadsheetKey($st_id); $query->setWorksheetId($wt_id); /* * Parse cell id */ // min length is 4 if (strlen($cell_id) < 4) { throw new Exception(); } $matches = array(); preg_match("/^R(\\d+)C(\\d+)\$/", $cell_id, $matches); $query->setMaxRow($matches[1])->setMinRow($matches[1])->setMaxCol($matches[2])->setMinCol($matches[2]); return $this->getFeed($query->getQueryUrl()); }