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

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -