opensheet test
| Date | Name | Favorite number | Twice the favorite number | |
|---|---|---|---|---|
| Joe | ||||
| አማርኛ | ||||
| Sam | ||||
| Kathy | ||||
| Arnold | ||||
| Sarah | ||||
| Timmy | ||||
| Rachel | ||||
| Jared | ||||
| George | ||||
| Dave | ||||
| Jeffrey | ||||
type = regular
columns = [
{
"title": "",
"type": "numeric",
"lengthMin": 1,
"lengthMax": 2
},
{
"title": "Date",
"type": "numeric",
"lengthMin": 9,
"lengthMax": 10
},
{
"title": "Name",
"type": "string",
"lengthMin": 3,
"lengthMax": 7
},
{
"title": "Favorite number",
"type": "numeric",
"lengthMin": 4,
"lengthMax": 5
},
{
"title": "Twice the favorite number",
"type": "numeric",
"lengthMin": 1,
"lengthMax": 2
}
] rows = [
[
{
"value": "1",
"rendered": "01"
},
{
"value": "2021-10-1",
"rendered": "2021-10-01"
},
{
"value": "Joe",
"rendered": "Joe"
},
{
"value": "1.00",
"rendered": "01.00"
},
{
"value": "2",
"rendered": "02"
}
],
[
{
"value": "2",
"rendered": "02"
},
{
"value": "2021-10-2",
"rendered": "2021-10-02"
},
{
"value": "አማርኛ",
"rendered": "አማርኛ"
},
{
"value": "2.00",
"rendered": "02.00"
},
{
"value": "4",
"rendered": "04"
}
],
[
{
"value": "3",
"rendered": "03"
},
{
"value": "2021-10-3",
"rendered": "2021-10-03"
},
{
"value": "Sam",
"rendered": "Sam"
},
{
"value": "3.00",
"rendered": "03.00"
},
{
"value": "6",
"rendered": "06"
}
],
[
{
"value": "4",
"rendered": "04"
},
{
"value": "2021-10-4",
"rendered": "2021-10-04"
},
{
"value": "Kathy",
"rendered": "Kathy"
},
{
"value": "4.00",
"rendered": "04.00"
},
{
"value": "8",
"rendered": "08"
}
],
[
{
"value": "5",
"rendered": "05"
},
{
"value": "2021-10-5",
"rendered": "2021-10-05"
},
{
"value": "Arnold",
"rendered": "Arnold"
},
{
"value": "5.00",
"rendered": "05.00"
},
{
"value": "10",
"rendered": "10"
}
],
[
{
"value": "6",
"rendered": "06"
},
{
"value": "2021-10-6",
"rendered": "2021-10-06"
},
{
"value": "Sarah",
"rendered": "Sarah"
},
{
"value": "6.00",
"rendered": "06.00"
},
{
"value": "12",
"rendered": "12"
}
],
[
{
"value": "7",
"rendered": "07"
},
{
"value": "2021-10-7",
"rendered": "2021-10-07"
},
{
"value": "Timmy",
"rendered": "Timmy"
},
{
"value": "7.00",
"rendered": "07.00"
},
{
"value": "14",
"rendered": "14"
}
],
[
{
"value": "8",
"rendered": "08"
},
{
"value": "2021-10-8",
"rendered": "2021-10-08"
},
{
"value": "Rachel",
"rendered": "Rachel"
},
{
"value": "8.00",
"rendered": "08.00"
},
{
"value": "16",
"rendered": "16"
}
],
[
{
"value": "9",
"rendered": "09"
},
{
"value": "2021-10-9",
"rendered": "2021-10-09"
},
{
"value": "Jared",
"rendered": "Jared"
},
{
"value": "9.00",
"rendered": "09.00"
},
{
"value": "18",
"rendered": "18"
}
],
[
{
"value": "10",
"rendered": "10"
},
{
"value": "2021-10-10",
"rendered": "2021-10-10"
},
{
"value": "George",
"rendered": "George"
},
{
"value": "10.00",
"rendered": "10.00"
},
{
"value": "20",
"rendered": "20"
}
],
[
{
"value": "11",
"rendered": "11"
},
{
"value": "2021-10-11",
"rendered": "2021-10-11"
},
{
"value": "Dave",
"rendered": "Dave"
},
{
"value": "11.00",
"rendered": "11.00"
},
{
"value": "22",
"rendered": "22"
}
],
[
{
"value": "12",
"rendered": "12"
},
{
"value": "2021-10-12",
"rendered": "2021-10-12"
},
{
"value": "Jeffrey",
"rendered": "Jeffrey"
},
{
"value": "12.00",
"rendered": "12.00"
},
{
"value": "24",
"rendered": "24"
}
]
] doc = {
"idLong": "s.1o5t26He2DzTweYeleXOGiDjlU4Jkx896f95VUHVgS8U",
"json": {
"title": "opensheet test",
"timeZone": "America/New_York",
"sheetTitle": "Test Sheet",
"rows": [
[
"Date",
"Name",
"Favorite number",
"Twice the favorite number"
],
[
[
"2021-10-1",
1633060800000
],
"Joe",
"1.00",
"2"
],
[
[
"2021-10-2",
1633147200000
],
"አማርኛ",
"2.00",
"4"
],
[
[
"2021-10-3",
1633233600000
],
"Sam",
"3.00",
"6"
],
[
[
"2021-10-4",
1633320000000
],
"Kathy",
"4.00",
"8"
],
[
[
"2021-10-5",
1633406400000
],
"Arnold",
"5.00",
"10"
],
[
[
"2021-10-6",
1633492800000
],
"Sarah",
"6.00",
"12"
],
[
[
"2021-10-7",
1633579200000
],
"Timmy",
"7.00",
"14"
],
[
[
"2021-10-8",
1633665600000
],
"Rachel",
"8.00",
"16"
],
[
[
"2021-10-9",
1633752000000
],
"Jared",
"9.00",
"18"
],
[
[
"2021-10-10",
1633838400000
],
"George",
"10.00",
"20"
],
[
[
"2021-10-11",
1633924800000
],
"Dave",
"11.00",
"22"
],
[
[
"2021-10-12",
1634011200000
],
"Jeffrey",
"12.00",
"24"
],
[
""
],
[
""
]
],
"hiddenColumns": [],
"hiddenRows": []
},
"timeZone": "America/New_York",
"title": "opensheet test",
"url": "https://sheets.googleapis.com/v4/spreadsheets/1o5t26He2DzTweYeleXOGiDjlU4Jkx896f95VUHVgS8U?ranges=A%3AZZZ&fields=properties%28title%2CtimeZone%29%2Csheets.properties%28title%29%2Csheets.data%28columnMetadata.hiddenByUser%2CrowMetadata.hiddenByUser%29%2Csheets.data.rowData.values%28formattedValue%2CeffectiveValue.numberValue%2CuserEnteredFormat.numberFormat%29&key=GCP_API_KEY",
"type": "sheet"
}{
"indexSheet": 0,
"googleDocuments": [
{
"idLong": "s.1o5t26He2DzTweYeleXOGiDjlU4Jkx896f95VUHVgS8U",
"json": {
"title": "opensheet test",
"timeZone": "America/New_York",
"sheetTitle": "Test Sheet",
"rows": [
[
"Date",
"Name",
"Favorite number",
"Twice the favorite number"
],
[
[
"2021-10-1",
1633060800000
],
"Joe",
"1.00",
"2"
],
[
[
"2021-10-2",
1633147200000
],
"አማርኛ",
"2.00",
"4"
],
[
[
"2021-10-3",
1633233600000
],
"Sam",
"3.00",
"6"
],
[
[
"2021-10-4",
1633320000000
],
"Kathy",
"4.00",
"8"
],
[
[
"2021-10-5",
1633406400000
],
"Arnold",
"5.00",
"10"
],
[
[
"2021-10-6",
1633492800000
],
"Sarah",
"6.00",
"12"
],
[
[
"2021-10-7",
1633579200000
],
"Timmy",
"7.00",
"14"
],
[
[
"2021-10-8",
1633665600000
],
"Rachel",
"8.00",
"16"
],
[
[
"2021-10-9",
1633752000000
],
"Jared",
"9.00",
"18"
],
[
[
"2021-10-10",
1633838400000
],
"George",
"10.00",
"20"
],
[
[
"2021-10-11",
1633924800000
],
"Dave",
"11.00",
"22"
],
[
[
"2021-10-12",
1634011200000
],
"Jeffrey",
"12.00",
"24"
],
[
""
],
[
""
]
],
"hiddenColumns": [],
"hiddenRows": []
},
"timeZone": "America/New_York",
"title": "opensheet test",
"url": "https://sheets.googleapis.com/v4/spreadsheets/1o5t26He2DzTweYeleXOGiDjlU4Jkx896f95VUHVgS8U?ranges=A%3AZZZ&fields=properties%28title%2CtimeZone%29%2Csheets.properties%28title%29%2Csheets.data%28columnMetadata.hiddenByUser%2CrowMetadata.hiddenByUser%29%2Csheets.data.rowData.values%28formattedValue%2CeffectiveValue.numberValue%2CuserEnteredFormat.numberFormat%29&key=GCP_API_KEY",
"type": "sheet"
}
]
}