public function testUpdateCell()
{
$this->gdata->updateCell(5, 1, 'updated data', $this->sprKey, $this->wksId);
$query = new Zend_Gdata_Spreadsheets_CellQuery();
$query->setSpreadsheetKey($this->sprKey);
$query->setCellId('R5C1');
$entry = $this->gdata->getCellEntry($query);
$this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_CellEntry);
$this->assertTrue($entry->cell->getText() == 'updated data');
$this->gdata->updateCell(5, 1, '', $this->sprKey, $this->wksId);
}
/**
* Updates an existing cell.
*
* @param int $row The row containing the cell to update
* @param int $col The column containing the cell to update
* @param int $inputValue The new value for the cell
* @param string $key The key for the spreadsheet to be updated
* @param string $wkshtId (optional) The worksheet to be updated
* @return CellEntry The updated cell entry.
*/
public function updateCell($row, $col, $inputValue, $key, $wkshtId = 'default')
{
$cell = 'R' . $row . 'C' . $col;
$query = new Zend_Gdata_Spreadsheets_CellQuery();
$query->setSpreadsheetKey($key);
$query->setWorksheetId($wkshtId);
$query->setCellId($cell);
$entry = $this->getCellEntry($query);
$entry->setCell(new Zend_Gdata_Spreadsheets_Extension_Cell(null, $row, $col, $inputValue));
$response = $entry->save();
return $response;
}
