Skip to content

Instantly share code, notes, and snippets.

@svamja
svamja / ascii_codes.json
Last active August 5, 2023 04:44
ASCII Code Special Characters and Description JSON
[
{
"decimal": 0,
"hexa": "0",
"html": "�",
"character": "NUL",
"description": null
},
{
"decimal": 1,
@svamja
svamja / sheet_append_with_formatting.php
Last active October 9, 2023 10:26
PHP Google Sheets API v4 - Working example to append rows with formatting
<?php
function append_rows_with_formatting($service, $sheet_id) {
$cell = [
'userEnteredFormat' => [
'numberFormat' => [
'type' => 'NUMBER',
'pattern' => '[Color22]0.00', // '[Blue]#.##'
],
"backgroundColor" => [