public Spreadsheet createSpreadsheet(String title, Sheet... sheets) throws IOException { return sheetsService.spreadsheets().create(new Spreadsheet().setSheets(Arrays.asList(sheets)) .setProperties(new SpreadsheetProperties().setTitle(title))).execute(); }
public static Spreadsheet toSpreadsheet(final File file) { final Spreadsheet result = new Spreadsheet(); result.setSpreadsheetId(file.getId()); // add both Wallet and People sheets to all spreadsheets, just to make testing easier result.setSheets(Arrays.asList(getSheet("Wallet", 0), getSheet("People", 1))); return result; } }