public BatchUpdateValuesResponse writeValuesIntoSpreadsheet(String spreadsheetId, String range, List<List<Object>> insertValues) throws IOException { List<ValueRange> data = new ArrayList<>(); data.add(new ValueRange().setRange(range).setValues(insertValues)); BatchUpdateValuesRequest body = new BatchUpdateValuesRequest().setValueInputOption(InputOption.USER_ENTERED.name()).setData(data); return sheetsService.spreadsheets().values().batchUpdate(spreadsheetId, body).execute(); }
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; }