Rust Requires Chilkat v11.0.0+

Google Sheets - Update (Set Values in a Range)

See more Google Sheets Examples

Sets values in a range of a spreadsheet. This example will demonstrate by first getting a range, then changing some values in the JSON, and then HTTPS PUT the changes back to the Google Sheet. Rust

// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

// This example uses a previously obtained access token having permission for the 
// Google Sheets scope.

// In this example, Get Google Sheets OAuth2 Access Token, the access
// token was saved to a JSON file.  This example fetches the access token from the file..
let json_token = chilkat::JsonObject::new();
let _ = json_token.load_file("qa_data/tokens/googleSheets.json").is_ok();
if !json_token.has_member("access_token") {
    println!("No access token found.");
    return;
}

let http = chilkat::Http::new();
http.set_auth_token(&json_token.string_of("access_token").unwrap_or_default());

// First get the cells in the range A1:B5
let _ = http.set_url_var("range", "Sheet1!A1:B5");
let _ = http.set_url_var("spreadsheetId", "1_SO2L-Y6nCayNpNppJLF0r9yHB2UnaCleGCKeE4O0SA");
let Ok(json_response) = http.quick_get_str("https://sheets.googleapis.com/v4/spreadsheets/{$spreadsheetId}/values/{$range}") else {
    println!("{}", http.last_error_text());
    return;
};

println!("{}", json_response);

let json = chilkat::JsonObject::new();
json.set_emit_compact(false);
let _ = json.load(&json_response);

// A sample response is shown below.

// {
//   "range": "Sheet1!A1:B5",
//   "majorDimension": "ROWS",
//   "values": [
//     [
//       "Item",
//       "Cost"
//     ],
//     [
//       "Wheel",
//       "$20.50"
//     ],
//     [
//       "Door",
//       "$15"
//     ],
//     [
//       "Engine",
//       "$100"
//     ],
//     [
//       "Totals",
//       "$135.50"
//     ]
//   ]
// }

// We're going to change the cost of the Engine to $120, and the Totals to $155.50

json.set_i(3);
json.set_j(1);
let _ = json.update_string("values[i][j]", "$120");
json.set_i(4);
let _ = json.update_string("values[i][j]", "$155.50");

// Show the updated JSON.
println!("{}", json.emit().unwrap_or_default());

// Update the Google Sheet using a PUT request.
json.set_emit_compact(true);
let url_to_update = "https://sheets.googleapis.com/v4/spreadsheets/{$spreadsheetId}/values/{$range}?valueInputOption=USER_ENTERED".to_string();
let xyz = http.quick_get_str(&url_to_update).unwrap_or_default();
let resp = chilkat::HttpResponse::new();
if http.http_json("PUT", &url_to_update, &json, "application/json", &resp).is_err() {
    println!("{}", http.last_error_text());
    return;
}

// Examine the response..
println!("response status code = {}", resp.status_code());
println!("response body:");
println!("{}", resp.body_str());

// A sample response body:

// {
//   "spreadsheetId": "1_SO2L-Y6nCayNpNppJLF0r9yHB2UnaCleGCKeE4O0SA",
//   "updatedRange": "Sheet1!A1:B5",
//   "updatedRows": 5,
//   "updatedColumns": 2,
//   "updatedCells": 10
// }