How can I add a single cell to a Google Spreadsheet using the Sheets API without using batching? -
a similar question asked not answered 2 , half years ago.
i have looked @ google's documention on both modifying cells , adding cells using batch updates. however, trying add single cell without using batching mechanism, , there seems no documented way of doing it.
here have tried. note entry trying add not have value, why linked documentation not allow me "change" contents of cell. in particular, cellfeed
not contain cell trying add value of.
cellentry otherentryfromcellfeed = // obtained through oauth , finding sheet, worksheet, , cellfeed, documented above cellentry cellentry = new cellentry(5, 10, "value"); cellentry.setservice(otherentryfromcellfeed.getservice()); cellentry.update();
error:
exception in thread "main" java.lang.unsupportedoperationexception: entry cannot updated @ com.google.gdata.data.baseentry.update(baseentry.java:635)
after hour of poking through javadocs spreadsheetservice , googleservice, discovered insert
method work cell feed, uses cellfeedurl
incomplete sheets doc.
cellentry cellentry = new cellentry(5, 10, "value"); service.insert(cellfeedurl, cellentry);
Comments
Post a Comment