@Test public void testConditionalFormat() throws IOException { String spreadsheetId = this.createTestSpreadsheet(); this.populateValuesWithNumbers(spreadsheetId); BatchUpdateSpreadsheetResponse response = this.snippets.conditionalFormat(spreadsheetId); assertEquals(spreadsheetId, response.getSpreadsheetId()); assertEquals(2, response.getReplies().size()); }
@Test public void testBatchUpdate() throws IOException { String spreadsheetId = this.createTestSpreadsheet(); this.populateValuesWithStrings(spreadsheetId); BatchUpdateSpreadsheetResponse response = this.snippets.batchUpdate(spreadsheetId, "New Title", "Hello", "Goodbye"); List<Response> replies = response.getReplies(); assertEquals(2, replies.size()); FindReplaceResponse findReplaceResponse = replies.get(1).getFindReplace(); assertEquals(100, findReplaceResponse.getOccurrencesChanged().intValue()); }
public BatchUpdateSpreadsheetResponse batchUpdate(String spreadsheetId, String title, String find, String replacement) throws IOException { Sheets service = this.service; // [START sheets_batch_update] List<Request> requests = new ArrayList<>(); // Change the spreadsheet's title. requests.add(new Request() .setUpdateSpreadsheetProperties(new UpdateSpreadsheetPropertiesRequest() .setProperties(new SpreadsheetProperties() .setTitle(title)) .setFields("title"))); // Find and replace text. requests.add(new Request() .setFindReplace(new FindReplaceRequest() .setFind(find) .setReplacement(replacement) .setAllSheets(true))); // Add additional requests (operations) ... BatchUpdateSpreadsheetRequest body = new BatchUpdateSpreadsheetRequest().setRequests(requests); BatchUpdateSpreadsheetResponse response = service.spreadsheets().batchUpdate(spreadsheetId, body).execute(); FindReplaceResponse findReplaceResponse = response.getReplies().get(1).getFindReplace(); System.out.printf("%d replacements made.", findReplaceResponse.getOccurrencesChanged()); // [END sheets_batch_update] return response; }
BatchUpdateSpreadsheetResponse createSheetsResponse = service.spreadsheets() .batchUpdate(spreadsheetId, createSheetsBody).execute(); int sourceSheetId = createSheetsResponse.getReplies().get(0).getAddSheet().getProperties() .getSheetId(); int targetSheetId = createSheetsResponse.getReplies().get(1).getAddSheet().getProperties() .getSheetId();
.batchUpdate(spreadsheetId, body) .execute(); System.out.printf("%d cells updated.", result.getReplies().size());