Not able to access spreadsheet using google spreadsheet API

972 views Asked by At

I have this code where I am trying to access a spreadsheet that I have created.

public class ExpressionExample {

    private static URL cellFeedUrl;

    public static final String SPREADSHEET_URL = "https://spreadsheets.google.com/feeds/spreadsheets/private/full/1QWX-zOkBe36M7oC9sn6z8ZuccGt7Wg-IFwtynn379kM";

    public static void main(String[] args) throws Exception {

        File p12 = new File("key.p12");

        HttpTransport httpTransport = new NetHttpTransport();
        JacksonFactory jsonFactory = new JacksonFactory();

        String[] SCOPESArray = { SPREADSHEET_URL };
        final List SCOPES = Arrays.asList(SCOPESArray);
        GoogleCredential credential = new GoogleCredential.Builder()
                .setTransport(httpTransport)
                .setJsonFactory(jsonFactory)
                .setServiceAccountId("[email protected]")
                .setServiceAccountScopes(SCOPES)
                .setServiceAccountPrivateKeyFromP12File(p12).build();

        SpreadsheetService service = new SpreadsheetService("new data service ");

        service.setOAuth2Credentials(credential);

        URL metafeedUrl = new URL(SPREADSHEET_URL);

        SpreadsheetEntry spreadsheet = service.getEntry(metafeedUrl,
                SpreadsheetEntry.class);

        WorksheetEntry sheet = ((WorksheetEntry) spreadsheet.getWorksheets()
                .get(0));

        cellFeedUrl = spreadsheet.getWorksheets().get(0).getCellFeedUrl();

        CellEntry cellA1 = new CellEntry(1, 1, "3");
        CellEntry cellB1 = new CellEntry(1, 2, "high mech");

        String line = "=IF(A1<5,IF(B1={\"high mech\",\"low mech\",\"mid mech\"},10,IF(B1=\"electronic\",20,0)),IF(A1>=5,IF(B1=\"electronic\",40,0),0)) ";
        CellEntry cellc1 = new CellEntry(1, 3, line);

        service.insert(cellFeedUrl, cellA1);
        service.insert(cellFeedUrl, cellB1);
        service.insert(cellFeedUrl, cellc1);

        ExpressionExample e = new ExpressionExample();
        e.printCell(cellA1);
        e.printCell(cellB1);
        e.printCell(cellc1);

        CellQuery query = new CellQuery(cellFeedUrl);
        query.setMinimumRow(1);
        query.setMaximumRow(1);
        query.setMinimumCol(3);
        query.setMaximumCol(3);

        CellFeed feed = service.query(query, CellFeed.class);

        System.out.println(feed.getEntries().indexOf(cellc1));
        for (CellEntry entry : feed.getEntries()) {
            e.printCell(entry);
        }
    }

    public void printCell(CellEntry cell) {
        // String shortId = cell.getId().substring(cell.getId().lastIndexOf('/')
        // + 1);
        System.out.println(" -- Cell(" + "/" + ") formula("
                + cell.getCell().getInputValue() + ") numeric("
                + cell.getCell().getNumericValue() + ") value("
                + cell.getCell().getValue() + ")");
    }
}

I am getting below error while executing the program:

Exception in thread "main" ResourceNotFoundException: Not Found Entry not found

Any help would be appreciated.

1

There are 1 answers

2
KRR On

I think the Spreadsheet url that is used to get the entry should be:

"https://spreadsheets.google.com/feeds/spreadsheets/" + file Id

Try changing and see if you can get rid of that error.

Also check this for more info.