public void sendToSheets(String sheetId, Map<ClientType, Controller.LoadtestStats> results) { List<List<List<Object>>> values = getValuesList(results); try { service.spreadsheets().values().append(sheetId, "CPS", new ValueRange().setValues(values.get(0))).setValueInputOption("USER_ENTERED").execute(); service.spreadsheets().values().append(sheetId, "Kafka", new ValueRange().setValues(values.get(1))).setValueInputOption("USER_ENTERED").execute(); } catch (IOException e) { log.error("Error publishing to spreadsheet " + sheetId + ": " + e); } }
public UpdateValuesResponse updateValues(String spreadsheetId, String range, String valueInputOption, List<List<Object>> _values) throws IOException { Sheets service = this.service; // [START sheets_update_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); UpdateValuesResponse result = service.spreadsheets().values().update(spreadsheetId, range, body) .setValueInputOption(valueInputOption) .execute(); System.out.printf("%d cells updated.", result.getUpdatedCells()); // [END sheets_update_values] return result; }
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; }
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; }
@Override protected MockLowLevelHttpResponse respond(final String method, final String url) { final ValueRange range = new ValueRange(); final List<Object> row = Arrays.asList("", "123456", "", "", id); range.setValues(Collections.singletonList(row)); return new MockLowLevelHttpResponse().setContent(toJson(range)); } }
@Before public void setUp() { try { ValueRange valueRange = new ValueRange(); List<List<Object>> testValues = new ArrayList<>(); List<Object> testRowValues = new ArrayList<>(); testRowValues.add("testValueOne"); testRowValues.add("testValueTwo"); testValues.add(testRowValues); valueRange.setValues(testValues); when(auth.getSheetsService(anyString(), anyString())).thenReturn(sheetsClient); when(sheetsClient.spreadsheets()).thenReturn(spreadsheets); when(spreadsheets.values()).thenReturn(spreasheetsValues); when(spreasheetsValues.get(anyString(), anyString())).thenReturn(spreasheetsValuesGet); when(spreasheetsValuesGet.execute()).thenReturn(valueRange); } catch (Exception e) { fail(e.getMessage()); } }