How can we update a cell in Google Spreadsheet through a URL parameter?
I have a Google Spreadsheet that is intended for public access. However, I'd like to allow for URL parameter(s) through a user's browser that can help modify one or more cells of the spreadsheet before the entire spreadsheet is presented on the screen. See the example here.
Is something like this possible开发者_Go百科? https://spreadsheets.google.com/ccc?key=0AgvcQSA3jj3ydGlQV2E4bndaaWNEbnVqbU5hbk1Va0E&hl=en?B4=8 Can something like the URL above succeed in changing B4 to 8 before the spreadsheet is presented to the requesting user?
See this question. The question
I'm not sure if you can do it and open the spreadsheet with the same link (I've asked a question about that too), but if you read the answer by Serge insas (on the first question linked), mainly edit 2, you'll see how to use HTTP Get
to edit cells with a link.
精彩评论