public AppendValuesResponse appendValues(String spreadsheetId, String range, String valueInputOption, List<List<Object>> _values) throws IOException { Sheets service = this.service; // [START sheets_append_values] List<List<Object>> values = Arrays.asList( Arrays.asList( // Cell values ... ) // Additional rows ... ); // [START_EXCLUDE silent] values = _values; // [END_EXCLUDE] ValueRange body = new ValueRange() .setValues(values); AppendValuesResponse result = service.spreadsheets().values().append(spreadsheetId, range, body) .setValueInputOption(valueInputOption) .execute(); System.out.printf("%d cells appended.", result.getUpdates().getUpdatedCells()); // [END sheets_append_values] return result; }
@Test public void testAppendValues() throws IOException { String spreadsheetId = this.createTestSpreadsheet(); this.populateValuesWithStrings(spreadsheetId); List<List<Object>> values = Arrays.asList( Arrays.asList("A", "B"), Arrays.asList("C", "D")); AppendValuesResponse result = this.snippets.appendValues(spreadsheetId, "A1:B2", "USER_ENTERED", values); assertEquals("Sheet1!A1:J10", result.getTableRange()); UpdateValuesResponse updates = result.getUpdates(); assertEquals(2, updates.getUpdatedRows().intValue()); assertEquals(2, updates.getUpdatedColumns().intValue()); assertEquals(4, updates.getUpdatedCells().intValue()); }