![]() The reason this is non-trivial is the authentication part. I think it would be a lot easier if you could make your Google spreadsheet public, but I doubt that is advisable with sales data. I had started answering your question, but realized that it was much less trivial than I thought it was when I started playing with the OAuth 2.0 API. HttpRequest.Send "entry.0.single=" + column1 + "&entry.1.single=" + column2 + "&pageNumber=0&backupCache&submit=Submit" tRequestHeader "Content-Type", "application/x-www-form-urlencoded" Replace column1 with your desired values. Add a reference to "Microsoft XML, v3.0" before. Next we try to execute the form POST from our Excel sheet via the following code. You can test the entry now with curl if you have it on your system (replace the formkey placeholder with the formkey from your table): curl.exe -v -k "" -d "entry.0.single=test&entry.1.single=test2&pageNumber=0&backupCache=&submit=Submit" ![]() Now you can issue a simple post into the spreadsheet without OAuth.Copy the formkey value displayed in the link at the bottom of the form creation page.Add anything in the form description just to enable the Save button.Create a spreadsheet or open an existing one.You just need to prepare your spreadsheet to accept data entries via a form as follows: Google Spreadsheet allows data entry with a simple form, which means also that a HTTP POST will do the trick. You don't need OAuth or the spreadsheet API.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |