constructor

Creates a SpreadSheetCell object that allows you to apply available API methods to the specified cell.

Parameters

$res - (string) the connection variable. Note, connection is established based on a configuration defined in the config.php file
$sheetId - (string) the id of a spreadsheet to manage
$cell - (string) the cell coordinates
$prefix - (string) the database prefix. Can be taken from the config.php file

Example

<?php
 
require_once("api.php");
require_once("config.php");
 
$res = new PDO("mysql:dbname=$db_name;host=$db_host", $db_user, $db_pass);
 
$cell = new SpreadSheetCell($res, "1","B1", $db_prefix);
?>

Note, you can also get a SpreadSheetCell object by calling the getCell method of the SpreadSheet class.