public Request setCellsStyle(int sheetId, int startRowIndex, int endRowIndex, int startColumnIndex, int endColumnIndex, boolean center, int fontSize, String fontFamily, boolean bold) { return new Request().setRepeatCell(new RepeatCellRequest() .setCell(new CellData().setUserEnteredFormat(new CellFormat().setHorizontalAlignment(center ? "CENTER" : null).setTextFormat( new TextFormat().setFontSize(fontSize).setFontFamily(fontFamily).setBold(bold)))) .setRange(new GridRange().setSheetId(sheetId) .setStartRowIndex(startRowIndex).setEndRowIndex(endRowIndex) .setStartColumnIndex(startColumnIndex).setEndColumnIndex(endColumnIndex)).setFields("*")); }
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(); } }