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 String create(String title) throws IOException { Sheets service = this.service; // [START sheets_create] Spreadsheet spreadsheet = new Spreadsheet() .setProperties(new SpreadsheetProperties() .setTitle(title)); spreadsheet = service.spreadsheets().create(spreadsheet) .setFields("spreadsheetId") .execute(); System.out.println("Spreadsheet ID: " + spreadsheet.getSpreadsheetId()); // [END sheets_create] return spreadsheet.getSpreadsheetId(); }
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; } }
protected String createTestSpreadsheet() throws IOException { Spreadsheet spreadsheet = new Spreadsheet() .setProperties(new SpreadsheetProperties() .setTitle("Test Spreadsheet")); spreadsheet = service.spreadsheets().create(spreadsheet) .setFields("spreadsheetId") .execute(); return spreadsheet.getSpreadsheetId(); }