write in a specific cell? about simplexlsxgen HOT 5 CLOSED

require_once 'simplexlsxgen.php';

class cfrrSimpleXLSXGen extends Shuchkin\SimpleXLSXGen
{
	protected $name2sheet;
	public function __construct()
	{
		parent::__construct();
		$name2sheet = [];
	}

	public function addSheet(array $rows, $name = null)
	{
		parent::addSheet($rows, $name);
		$this->name2sheet[$this->sheets[$this->curSheet]['name']] = $this->curSheet;
	}

	/*
	$cell : a string referencing the cell to modify in A1 notation (column letter / row number)
	$data : the cell data to modify
	$sheet : if type
		= null : the current (last) sheet
		= integer : the sheet number (X)
 		= string : the sheet name
	*/
	public function modifyCell($cell, $data, $sheet = null)
	{
		$x = $y = 0;
		$this->cell2coord($cell, $x, $y);
		if ($sheet === null) {
			$sheet = $this->curSheet;
		} elseif (is_string($sheet)) {
			if (!isset($this->name2sheet[$sheet]))
				return;
			$sheet = $this->name2sheet[$sheet];
		}
		if (!isset($this->sheets[$sheet]))
			return;
		$this->sheets[$sheet]['rows'][$y][$x] = $data;
	}

	/*
	$row : unidimensional array representing a row to add to the end of $sheet
	$sheet : if type
		= null : the current (last) sheet
		= integer : the sheet number (X)
		= string : the sheet name
	*/
	public function addRow($row, $sheet = null)
	{
		if ($sheet === null) {
			$sheet = $this->curSheet;
		} elseif (is_string($sheet)) {
			if (!isset($this->name2sheet[$sheet]))
				return;
			$sheet = $this->name2sheet[$sheet];
		}
		if (!isset($this->sheets[$sheet]))
			return;
		$this->sheets[$sheet]['rows'][] = $row;
	}
}

$xlsx = new cfrrSimpleXLSXGen();
//generate random data
$data = [];
for ($i=0; $i<10; $i++) {
	$data[] = [rand(0, 10), rand(0, 10), rand(0, 10), rand(0, 10)];
}
//add to ne sheet
$xlsx->addSheet($data, 'Test Sheet');
$xlsx->modifyCell('B4', 'Hello World!', 'Test Sheet');
$xlsx->saveAs('Test.xlsx');