Set explicit value of a cell (alphabet coordinate)

By data type

if($field[3] == 'int'){
	$sheet->setCellValue($coordinate, $value);
}elseif($field[3] == 'date'){
	$sheet->setCellValue($coordinate, $value);

	$sheet->getStyle($coordinate)
		->getNumberFormat()
		->setFormatCode(
			\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME
		);
}else{
	$sheet->setCellValueExplicit(
		$coordinate,
		$value,
		\PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING
	);
}

if($field[3] == 'int'){

$sheet->setCellValue($coordinate, $value);

}elseif($field[3] == 'date'){

$sheet->setCellValue($coordinate, $value);

$sheet->getStyle($coordinate)

->getNumberFormat()

->setFormatCode(

\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME

);

}else{

$sheet->setCellValueExplicit(

$coordinate,

$value,

\PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING

);

}

https://phpspreadsheet.readthedocs.io/en/latest/topics/accessing-cells/

M	T	W	T	F	S	S
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Set explicit value of a cell (alphabet coordinate)