Search in sources :

Example 1 with GridProperties

use of com.google.api.services.sheets.v4.model.GridProperties in project collect by opendatakit.

the class SheetsHelper method resizeSpreadSheet.

/**
 * Resize the column size of the provided sheetId in the google spreadsheet
 *
 * @param spreadsheetId unique id of the spreadsheet
 * @param sheetId       the index of the sheet which is to be resized
 * @param columnSize    the new column size of the sheet
 * @throws IllegalArgumentException Providing sheetId or column size less than zero throws this exception
 *                                  Sheet Id is basically index of the sheet starting from zero
 *                                  Similarly, the value for the column size can't be negative
 * @throws IOException              Throws this exception if the google spreadsheet cannot be fetched
 *                                  due to insufficient permissions or invalid sheet id
 */
public void resizeSpreadSheet(String spreadsheetId, int sheetId, int columnSize) throws IllegalArgumentException, IOException {
    if (sheetId < 0) {
        throw new IllegalArgumentException("Sheet Id should be greater than or equal to 0");
    }
    if (columnSize < 1) {
        throw new IllegalArgumentException("Column size should be greater than 0");
    }
    // create grid properties with the new column size
    GridProperties gridProperties = new GridProperties().setColumnCount(columnSize);
    // create sheet properties for the first sheet in the spreadsheet
    SheetProperties sheetProperties = new SheetProperties().setSheetId(sheetId).setGridProperties(gridProperties);
    // Updates properties of the sheet with the specified sheetId
    UpdateSheetPropertiesRequest updateSheetPropertyRequest = new UpdateSheetPropertiesRequest().setProperties(sheetProperties).setFields("gridProperties.columnCount");
    // generate request
    List<Request> requests = new ArrayList<>();
    requests.add(new Request().setUpdateSheetProperties(updateSheetPropertyRequest));
    // send the API request
    sheetsService.batchUpdate(spreadsheetId, requests);
}
Also used : UpdateSheetPropertiesRequest(com.google.api.services.sheets.v4.model.UpdateSheetPropertiesRequest) GridProperties(com.google.api.services.sheets.v4.model.GridProperties) SheetProperties(com.google.api.services.sheets.v4.model.SheetProperties) AddSheetRequest(com.google.api.services.sheets.v4.model.AddSheetRequest) BatchUpdateSpreadsheetRequest(com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest) UpdateSpreadsheetPropertiesRequest(com.google.api.services.sheets.v4.model.UpdateSpreadsheetPropertiesRequest) Request(com.google.api.services.sheets.v4.model.Request) UpdateSheetPropertiesRequest(com.google.api.services.sheets.v4.model.UpdateSheetPropertiesRequest) ArrayList(java.util.ArrayList)

Aggregations

AddSheetRequest (com.google.api.services.sheets.v4.model.AddSheetRequest)1 BatchUpdateSpreadsheetRequest (com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest)1 GridProperties (com.google.api.services.sheets.v4.model.GridProperties)1 Request (com.google.api.services.sheets.v4.model.Request)1 SheetProperties (com.google.api.services.sheets.v4.model.SheetProperties)1 UpdateSheetPropertiesRequest (com.google.api.services.sheets.v4.model.UpdateSheetPropertiesRequest)1 UpdateSpreadsheetPropertiesRequest (com.google.api.services.sheets.v4.model.UpdateSpreadsheetPropertiesRequest)1 ArrayList (java.util.ArrayList)1