Examples of SpreadsheetEntry


Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

   
    private List<WorksheetEntry> getWorksheetEntriesForDoc(URL docUrl, String token) throws IOException, ServiceException {
        if (token != null) {
            try {
                SpreadsheetService spreadsheetService = GDataExtension.getSpreadsheetService(token);
                SpreadsheetEntry spreadsheetEntry = spreadsheetService.getEntry(docUrl, SpreadsheetEntry.class);
                return spreadsheetEntry.getWorksheets();
            } catch (ServiceException e) {
                // Ignore and fall through, pretending that we're not logged in.
            }
        }
        return getWorksheetEntriesForDoc(docUrl);
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

       
        try {
            WorksheetEntry worksheetEntry = service.getEntry(worksheetURL, WorksheetEntry.class);
            String spreadsheetName = docURL.toExternalForm();
            try {
                SpreadsheetEntry spreadsheetEntry = service.getEntry(docURL, SpreadsheetEntry.class);
                spreadsheetName = spreadsheetEntry.getTitle().getPlainText();
            } catch (ServiceException e) { // RedirectRequiredException among others
                // fall back to just using the URL (better for traceability anyway?)
            }
           
            String fileSource = spreadsheetName + " # " +
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

    final UserService user = UserServiceFactory.getUserService();
    final User currentUser = user.getCurrentUser();

    // Craete new spreadsheet
    GbSpreadsheetService gss = new GbSpreadsheetService(token);
    SpreadsheetEntry spreadsheet;
    while (true) {
      try {
        spreadsheet = gss.createSpreadsheet(Arrays.asList(kinds));
        break;
      } catch (IOException ioe) {
        // retry when timeout.
      }
    }
    logger.fine("ssKey=" + spreadsheet.getKey());

    List<Key> putKeys = null;
    try {
      // Prepare control table.
      Key controlId = datastore.allocateIds("dump", 1).getStart();
      List<Entity> list = new ArrayList<Entity>();
      Queue queue = QueueFactory.getDefaultQueue();
      List<TaskOptions> taskList = Lists.newArrayList();
      int countDown = 10000;
      for (int i = 0; i < kinds.length; i++) {
        Key childKey = KeyFactory.createKey(controlId, GbControl.NAME, kinds[i]);
        Entity control = new Entity(childKey);
        control.setProperty(GbControl.KIND_NAME, kinds[i]);
        control.setProperty(GbControl.COUNT, 0);
        if (currentUser != null) {
          control.setProperty(GbControl.REPORT_TO, new Email(currentUser.getEmail()));
        }
        control.setProperty(GbControl.AUTH_SUB_TOKEN, token);
        control.setProperty(GbControl.SPREADSHEET_KEY, spreadsheet.getKey());
        control.setProperty(GbControl.UPDATE_DATE, new Date());
        list.add(control);

        // Start task queue chain for each kind.
        taskList
          .add(TaskOptions.Builder.url("/tasks/dump.gobo").param(
            "controlKey",
            KeyFactory.keyToString(childKey)).countdownMillis(countDown).method(
            Method.GET));

        // to avoid the collision on the spreadsheet.
        countDown += 500;
      }
      putKeys = datastore.put(list);
      queue.add(taskList);

    } catch (Exception e) {
      if (putKeys != null) {
        try {
          datastore.delete(putKeys);
        } catch (Exception e2) {
          e2.printStackTrace();
        }
      }
      throw e;
    }

    return redirect("started.gobo?docURL="
      + response.encodeRedirectURL(spreadsheet.getHtmlLink().getHref()));
  }
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

      FeedURLFactory urlFactory = FeedURLFactory.getDefault();
      SpreadsheetQuery spreadsheetQuery =
        new SpreadsheetQuery(urlFactory.getSpreadsheetsFeedUrl());
      spreadsheetQuery.setTitleQuery(fileName);
      SpreadsheetFeed spreadsheetFeed = ss.query(spreadsheetQuery, SpreadsheetFeed.class);
      SpreadsheetEntry spreadsheetEntry = spreadsheetFeed.getEntries().get(0);

      // Modify a default worksheet
      URL worksheetFeedUrl = spreadsheetEntry.getWorksheetFeedUrl();
      WorksheetFeed worksheetFeed = ss.getFeed(worksheetFeedUrl, WorksheetFeed.class);
      WorksheetEntry defaultWorksheet = worksheetFeed.getEntries().get(0);
      defaultWorksheet.setTitle(new PlainTextConstruct(targetKinds.get(0)));
      defaultWorksheet.setRowCount(2);
      defaultWorksheet.setColCount(1);
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

    // Search Spreadsheet
    FeedURLFactory urlFactory = FeedURLFactory.getDefault();
    SpreadsheetQuery spreadsheetQuery =
      new SpreadsheetQuery(urlFactory.getSpreadsheetsFeedUrl());
    SpreadsheetFeed spreadsheetFeed = ss.query(spreadsheetQuery, SpreadsheetFeed.class);
    SpreadsheetEntry spreadsheetEntry = null;
    for (SpreadsheetEntry entry : spreadsheetFeed.getEntries()) {
      if (ssKey.equals(entry.getKey())) {
        spreadsheetEntry = entry;
        logger.info("Spreadsheet:" + ssKey + " is found.");
        break;
      }
    }
    if (spreadsheetEntry == null) {
      throw new RuntimeException("Cannot find spreadsheet:" + ssKey);
    }

    // Modify a worksheet's column size
    URL worksheetFeedUrl = spreadsheetEntry.getWorksheetFeedUrl();
    WorksheetFeed worksheetFeed = ss.getFeed(worksheetFeedUrl, WorksheetFeed.class);
    WorksheetEntry worksheetEntry = null;
    for (WorksheetEntry worksheet : worksheetFeed.getEntries()) {
      if (kind.equals(worksheet.getTitle().getPlainText())) {
        worksheetEntry = worksheet;
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

    SpreadsheetFeed feed = service.getFeed(factory.getSpreadsheetsFeedUrl(),
        SpreadsheetFeed.class);
    List spreadsheets = feed.getEntries();
    int spreadsheetIndex = getIndexFromUser(reader, spreadsheets,
        "spreadsheet");
    SpreadsheetEntry spreadsheet = (SpreadsheetEntry) spreadsheets
        .get(spreadsheetIndex);

    URL spreadsheetUrl = new java.net.URL(
        spreadsheet.getSpreadsheetLink().getHref());
    String baseUrl = new java.net.URL(spreadsheetUrl.getProtocol() + "://"
        + spreadsheetUrl.getHost()).toString();
    tablesFeedUrl = new java.net.URL(baseUrl + "/feeds/" + spreadsheet.getKey()
        + "/tables");
    System.out.println("Sheet loaded.");
  }
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

   */
  private void fillSpreadsheetListBox() {
    String[] stringsForListbox = new String[spreadsheetEntries.size()];

    for (int i = 0; i < spreadsheetEntries.size(); i++) {
      SpreadsheetEntry entry = spreadsheetEntries.get(i);

      // Title of Spreadsheet (author, updated 2006-6-20 7:30PM)
      stringsForListbox[i] =
          entry.getTitle().getPlainText()
          + " (" + entry.getAuthors().get(0).getEmail()
          + ", updated " + entry.getUpdated().toUiString()
          + ")";
    }

    spreadsheetListBox.setListData(stringsForListbox);
  }
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

   */
  private void handleSpreadsheetSelection() {
    int selected = spreadsheetListBox.getSelectedIndex();

    if (spreadsheetEntries != null && selected >= 0) {
      SpreadsheetEntry entry = spreadsheetEntries.get(selected);

      ajaxLinkField.setText(
          entry.getHtmlLink().getHref());
      worksheetsFeedUrlField.setText(
          entry.getWorksheetFeedUrl().toExternalForm());
    }
  }
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

   */
  public void exportToSpreadsheet(
      String spreadsheetKey, String tableId, String startDate, String endDate)
      throws IOException, ServiceException {

    SpreadsheetEntry spreadsheet = getSpreadsheetWithKey(spreadsheetKey);
    Worksheet worksheet = new Worksheet(spreadsheet.getDefaultWorksheet(), spreadsheetService);

    ColumnTypeMap columnTypeMap = readAnalyticsColumns(worksheet);
    List<DataEntry> dataToUpload = getAnalyticsData(tableId, columnTypeMap, startDate, endDate);
    addDataToWorksheet(worksheet, columnTypeMap, dataToUpload);
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.