@Test public void testUpdateValues() throws IOException { String spreadsheetId = this.createTestSpreadsheet(); List<List<Object>> values = Arrays.asList( Arrays.asList("A", "B"), Arrays.asList("C", "D")); UpdateValuesResponse result = this.snippets.updateValues(spreadsheetId, "A1:B2", "USER_ENTERED", values); assertEquals(2, result.getUpdatedRows().intValue()); assertEquals(2, result.getUpdatedColumns().intValue()); assertEquals(4, result.getUpdatedCells().intValue()); }
@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()); }