@Test public void testBatchUpdateValues() throws IOException { String spreadsheetId = this.createTestSpreadsheet(); List<List<Object>> values = Arrays.asList( Arrays.asList("A", "B"), Arrays.asList("C", "D")); BatchUpdateValuesResponse result = this.snippets.batchUpdateValues(spreadsheetId, "A1:B2", "USER_ENTERED", values); assertEquals(1, result.getResponses().size()); assertEquals(2, result.getTotalUpdatedRows().intValue()); assertEquals(2, result.getTotalUpdatedColumns().intValue()); assertEquals(4, result.getTotalUpdatedCells().intValue()); }
public BatchUpdateValuesResponse batchUpdateValues(String spreadsheetId, String range, String valueInputOption, List<List<Object>> _values) throws IOException { Sheets service = this.service; // [START sheets_batch_update_values] List<List<Object>> values = Arrays.asList( Arrays.asList( // Cell values ... ) // Additional rows ... ); // [START_EXCLUDE silent] values = _values; // [END_EXCLUDE] List<ValueRange> data = new ArrayList<ValueRange>(); data.add(new ValueRange() .setRange(range) .setValues(values)); // Additional ranges to update ... BatchUpdateValuesRequest body = new BatchUpdateValuesRequest() .setValueInputOption(valueInputOption) .setData(data); BatchUpdateValuesResponse result = service.spreadsheets().values().batchUpdate(spreadsheetId, body).execute(); System.out.printf("%d cells updated.", result.getTotalUpdatedCells()); // [END sheets_batch_update_values] return result; }