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.
I think the Spreadsheet url that is used to get the entry should be:
Try changing and see if you can get rid of that error.
Also check this for more info.