Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Unicode C) Google Sheets Conditional Formatting - Color GradientAdd a conditional color gradient across a row For more information, see https://developers.google.com/sheets/api/samples/conditional-formatting#add_a_conditional_color_gradient_across_a_row
#include <C_CkHttpW.h> #include <C_CkJsonObjectW.h> #include <C_CkHttpResponseW.h> void ChilkatSample(void) { HCkHttpW http; BOOL success; const wchar_t *sheetId; HCkJsonObjectW json; HCkHttpResponseW resp; // This example assumes the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. http = CkHttpW_Create(); // 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 // } // } // ] // } sheetId = L"YOUR_SHEET_ID"; json = CkJsonObjectW_Create(); CkJsonObjectW_UpdateString(json,L"requests[0].addConditionalFormatRule.rule.ranges[0].sheetId",sheetId); CkJsonObjectW_UpdateInt(json,L"requests[0].addConditionalFormatRule.rule.ranges[0].startRowIndex",9); CkJsonObjectW_UpdateInt(json,L"requests[0].addConditionalFormatRule.rule.ranges[0].endRowIndex",10); CkJsonObjectW_UpdateNumber(json,L"requests[0].addConditionalFormatRule.rule.gradientRule.minpoint.color.green",L"0.2"); CkJsonObjectW_UpdateNumber(json,L"requests[0].addConditionalFormatRule.rule.gradientRule.minpoint.color.red",L"0.8"); CkJsonObjectW_UpdateString(json,L"requests[0].addConditionalFormatRule.rule.gradientRule.minpoint.type",L"MIN"); CkJsonObjectW_UpdateNumber(json,L"requests[0].addConditionalFormatRule.rule.gradientRule.maxpoint.color.green",L"0.9"); CkJsonObjectW_UpdateString(json,L"requests[0].addConditionalFormatRule.rule.gradientRule.maxpoint.type",L"MAX"); CkJsonObjectW_UpdateInt(json,L"requests[0].addConditionalFormatRule.index",0); CkJsonObjectW_UpdateString(json,L"requests[1].addConditionalFormatRule.rule.ranges[0].sheetId",sheetId); CkJsonObjectW_UpdateInt(json,L"requests[1].addConditionalFormatRule.rule.ranges[0].startRowIndex",10); CkJsonObjectW_UpdateInt(json,L"requests[1].addConditionalFormatRule.rule.ranges[0].endRowIndex",11); CkJsonObjectW_UpdateNumber(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.minpoint.color.green",L"0.8"); CkJsonObjectW_UpdateNumber(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.minpoint.color.red",L"0.8"); CkJsonObjectW_UpdateString(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.minpoint.type",L"NUMBER"); CkJsonObjectW_UpdateString(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.minpoint.value",L"0"); CkJsonObjectW_UpdateNumber(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.color.blue",L"0.9"); CkJsonObjectW_UpdateNumber(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.color.green",L"0.5"); CkJsonObjectW_UpdateNumber(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.color.red",L"0.5"); CkJsonObjectW_UpdateString(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.type",L"NUMBER"); CkJsonObjectW_UpdateString(json,L"requests[1].addConditionalFormatRule.rule.gradientRule.maxpoint.value",L"256"); CkJsonObjectW_UpdateInt(json,L"requests[1].addConditionalFormatRule.index",1); // Adds the "Authorization: Bearer ACCESS_TOKEN" header. CkHttpW_putAuthToken(http,L"ACCESS_TOKEN"); CkHttpW_SetRequestHeader(http,L"Content-Type",L"application/json"); resp = CkHttpW_PostJson3(http,L"https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate",L"application/json",json); if (CkHttpW_getLastMethodSuccess(http) == FALSE) { wprintf(L"%s\n",CkHttpW_lastErrorText(http)); CkHttpW_Dispose(http); CkJsonObjectW_Dispose(json); return; } wprintf(L"Status code: %d\n",CkHttpResponseW_getStatusCode(resp)); wprintf(L"Response body:\n"); wprintf(L"%s\n",CkHttpResponseW_bodyStr(resp)); CkHttpResponseW_Dispose(resp); CkHttpW_Dispose(http); CkJsonObjectW_Dispose(json); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.