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

Package com.google.gdata.data.spreadsheet

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

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

    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

   */
  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

   */
  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

   */
  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

0 1 2 3

TOP

Related Classes of com.google.gdata.data.spreadsheet.SpreadsheetEntry

com.casamind.adware.server.proxy.GDataDocumentsProxy

com.google.analytics.frontend.feed.examples.SpreadsheetExporter

com.google.refine.extension.gdata.GDataImporter

com.google.refine.extension.gdata.GDataImportingController

gobo.controller.dump.StartController

gobo.controller.restore.IndexControllerTest

gobo.controller.restore.SheetControllerTest

gobo.controller.tasks.DumpControllerTest

gobo.controller.tasks.DumpEndControllerTest

gobo.controller.tasks.RestoreControllerTest

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.