Visual FoxPro
Visual FoxPro
Google Sheets Conditional Formatting - Color Gradient
See more Google Sheets Examples
Add a conditional color gradient across a rowChilkat Visual FoxPro Downloads
LOCAL lnSuccess
LOCAL loHttp
LOCAL lcSheetId
LOCAL loJson
LOCAL loResp
lnSuccess = 0
* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
loHttp = CreateObject('Chilkat.Http')
* Implements the following CURL command:
* curl -H "Content-Type: application/json" \
* -H "Authorization: Bearer ACCESS_TOKEN" \
* -X POST \
* -d '{
* "requests": [
* {
* "addConditionalFormatRule": {
* "rule": {
* "ranges": [
* {
* "sheetId": sheetId,
* "startRowIndex": 9,
* "endRowIndex": 10,
* }
* ],
* "gradientRule": {
* "minpoint": {
* "color": {
* "green": 0.2,
* "red": 0.8
* },
* "type": "MIN"
* },
* "maxpoint": {
* "color": {
* "green": 0.9
* },
* "type": "MAX"
* },
* }
* },
* "index": 0
* }
* },
* {
* "addConditionalFormatRule": {
* "rule": {
* "ranges": [
* {
* "sheetId": sheetId,
* "startRowIndex": 10,
* "endRowIndex": 11,
* }
* ],
* "gradientRule": {
* "minpoint": {
* "color": {
* "green": 0.8,
* "red": 0.8
* },
* "type": "NUMBER",
* "value": "0"
* },
* "maxpoint": {
* "color": {
* "blue": 0.9,
* "green": 0.5,
* "red": 0.5
* },
* "type": "NUMBER",
* "value": "256"
* },
* }
* },
* "index": 1
* }
* },
* ]
* }' https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate
* Use the following online tool to generate HTTP code from a CURL command
* Convert a cURL Command to HTTP Source Code
* Use this online tool to generate code from sample JSON:
* Generate Code to Create JSON
* The following JSON is sent in the request body.
* {
* "requests": [
* {
* "addConditionalFormatRule": {
* "rule": {
* "ranges": [
* {
* "sheetId": sheetId,
* "startRowIndex": 9,
* "endRowIndex": 10
* }
* ],
* "gradientRule": {
* "minpoint": {
* "color": {
* "green": 0.2,
* "red": 0.8
* },
* "type": "MIN"
* },
* "maxpoint": {
* "color": {
* "green": 0.9
* },
* "type": "MAX"
* }
* }
* },
* "index": 0
* }
* },
* {
* "addConditionalFormatRule": {
* "rule": {
* "ranges": [
* {
* "sheetId": sheetId,
* "startRowIndex": 10,
* "endRowIndex": 11
* }
* ],
* "gradientRule": {
* "minpoint": {
* "color": {
* "green": 0.8,
* "red": 0.8
* },
* "type": "NUMBER",
* "value": "0"
* },
* "maxpoint": {
* "color": {
* "blue": 0.9,
* "green": 0.5,
* "red": 0.5
* },
* "type": "NUMBER",
* "value": "256"
* }
* }
* },
* "index": 1
* }
* }
* ]
* }
lcSheetId = "YOUR_SHEET_ID"
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("requests[0].addConditionalFormatRule.rule.ranges[0].sheetId",lcSheetId)
loJson.UpdateInt("requests[0].addConditionalFormatRule.rule.ranges[0].startRowIndex",9)
loJson.UpdateInt("requests[0].addConditionalFormatRule.rule.ranges[0].endRowIndex",10)
loJson.UpdateNumber("requests[0].addConditionalFormatRule.rule.gradientRule.minpoint.color.green","0.2")
loJson.UpdateNumber("requests[0].addConditionalFormatRule.rule.gradientRule.minpoint.color.red","0.8")
loJson.UpdateString("requests[0].addConditionalFormatRule.rule.gradientRule.minpoint.type","MIN")
loJson.UpdateNumber("requests[0].addConditionalFormatRule.rule.gradientRule.maxpoint.color.green","0.9")
loJson.UpdateString("requests[0].addConditionalFormatRule.rule.gradientRule.maxpoint.type","MAX")
loJson.UpdateInt("requests[0].addConditionalFormatRule.index",0)
loJson.UpdateString("requests[1].addConditionalFormatRule.rule.ranges[0].sheetId",lcSheetId)
loJson.UpdateInt("requests[1].addConditionalFormatRule.rule.ranges[0].startRowIndex",10)
loJson.UpdateInt("requests[1].addConditionalFormatRule.rule.ranges[0].endRowIndex",11)
loJson.UpdateNumber("requests[1].addConditionalFormatRule.rule.gradientRule.minpoint.color.green","0.8")
loJson.UpdateNumber("requests[1].addConditionalFormatRule.rule.gradientRule.minpoint.color.red","0.8")
loJson.UpdateString("requests[1].addConditionalFormatRule.rule.gradientRule.minpoint.type","NUMBER")
loJson.UpdateString("requests[1].addConditionalFormatRule.rule.gradientRule.minpoint.value","0")
loJson.UpdateNumber("requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.color.blue","0.9")
loJson.UpdateNumber("requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.color.green","0.5")
loJson.UpdateNumber("requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.color.red","0.5")
loJson.UpdateString("requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.type","NUMBER")
loJson.UpdateString("requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.value","256")
loJson.UpdateInt("requests[1].addConditionalFormatRule.index",1)
* Adds the "Authorization: Bearer ACCESS_TOKEN" header.
loHttp.AuthToken = "ACCESS_TOKEN"
loHttp.SetRequestHeader("Content-Type","application/json")
loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpJson("POST","https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate",loJson,"application/json",loResp)
IF (lnSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loJson
RELEASE loResp
CANCEL
ENDIF
? "Status code: " + STR(loResp.StatusCode)
? "Response body:"
? loResp.BodyStr
RELEASE loHttp
RELEASE loJson
RELEASE loResp