protected void populateValuesWithStrings(String spreadsheetId) throws IOException { List<Request> requests = new ArrayList<>(); requests.add(new Request().setRepeatCell(new RepeatCellRequest() .setRange(new GridRange() .setSheetId(0) .setStartRowIndex(0) .setEndRowIndex(10) .setStartColumnIndex(0) .setEndColumnIndex(10)) .setCell(new CellData() .setUserEnteredValue(new ExtendedValue() .setStringValue("Hello"))) .setFields("userEnteredValue"))); BatchUpdateSpreadsheetRequest body = new BatchUpdateSpreadsheetRequest() .setRequests(requests); service.spreadsheets().batchUpdate(spreadsheetId, body).execute(); }
protected void populateValuesWithNumbers(String spreadsheetId) throws IOException { List<Request> requests = new ArrayList<>(); requests.add(new Request().setRepeatCell(new RepeatCellRequest() .setRange(new GridRange() .setSheetId(0) .setStartRowIndex(0) .setEndRowIndex(10) .setStartColumnIndex(0) .setEndColumnIndex(10)) .setCell(new CellData() .setUserEnteredValue(new ExtendedValue() .setNumberValue(1337D))) .setFields("userEnteredValue"))); BatchUpdateSpreadsheetRequest body = new BatchUpdateSpreadsheetRequest() .setRequests(requests); service.spreadsheets().batchUpdate(spreadsheetId, body).execute(); } }