Skip to content

Instantly share code, notes, and snippets.

@jdraths
Last active September 15, 2017 17:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jdraths/8354d54fbd7b3a575e71b5db5beccb8f to your computer and use it in GitHub Desktop.
Save jdraths/8354d54fbd7b3a575e71b5db5beccb8f to your computer and use it in GitHub Desktop.
// params need to be snake cased with ruby api
{
"requests":
[
{
"setBasicFilter": {
"filter":
{
"range":
{
"sheetId": 0
}
}
}
},
{
"repeatCell": {
"range": {
"sheetId": 0,
"startRowIndex": 0,
"endRowIndex": 1
},
"cell": {
"userEnteredFormat": {
"backgroundColor": {
"red": 1.0,
"green": 1.0,
"blue": 1.0
},
"horizontalAlignment" : "LEFT",
"textFormat": {
"foregroundColor": {
"red": 0.0,
"green": 0.0,
"blue": 0.0
},
"fontSize": 10,
"bold": true
}
}
},
"fields": "userEnteredFormat(backgroundColor,textFormat,horizontalAlignment)"
}
},
{
"updateBorders": {
"range": {
"sheetId": 0,
"startRowIndex": 0,
"endRowIndex": 0,
},
"top": {
"style": "SOLID",
"width": 1,
"color": {
"red": 1.0,
"green": 1.0,
"blue": 1.0
},
},
"bottom": {
"style": "SOLID",
"width": 1,
"color": {
"red": 1.0,
"green": 1.0,
"blue": 1.0
},
},
}
},
{
"updateSheetProperties": {
"properties": {
"sheetId": 0,
"gridProperties": {
"frozenRowCount": 1
}
},
"fields": "gridProperties.frozenRowCount"
}
},
{
"addBanding": {
"bandedRange": {
"bandedRangeId": 12346,
"range": {
"sheetId": 0,
},
"rowProperties": {
"headerColor": {
"red": 1,
"green": 1,
"blue": 1,
"alpha": 1,
},
"firstBandColor": {
"red": 0.89,
"green": 0.89,
"blue": 0.89,
"alpha": 0,
},
"secondBandColor": {
"red": 1,
"green": 1,
"blue": 1,
"alpha": 0,
}
}
}
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment