hi,
i need to save sensor data in excel sheet through online can any one suggest me a model project pls...and one more thing how to get the form key of google form .....
hi,
i need to save sensor data in excel sheet through online can any one suggest me a model project pls...and one more thing how to get the form key of google form .....
Hi Indira,
Would you prefer to implement real-time data acquisition directly from your arduino into Excel - where every data point sent by the arduino immediately gets placed in a new cell in the spreadsheet; or do you prefer to store data from your arduino to the cloud and import it later into Excel?
How far apart (physically) are the arduino and the Excel computer?
I just did a bit of investigating and it looks like Google may not be supporting un secure channel with Docs now, you need SSL and the use of their APIs (Beyond Arduino Viability or atleast the MEGA range of chips as they do not have enough resources to handle SSL / Encryption. A bigger board may be possible to do this like the Due or Yun.
here is a link to what I found and also my searching through Google info https://productforums.google.com/forum/#!msg/docs/f4hJKF1OQOw/877WUgNHsUcJ
I will still figure the code for using the SD card locally and how to get it to a computer on the local network. The above link does describe a workaround but you need to subscribe to a third party service and presumably give them some of your credentials to access the forms..
Peter
I just did a bit of investigating and it looks like Google may not be supporting un secure channel with Docs now, you need SSL and the use of their APIs (Beyond Arduino Viability or atleast the MEGA range of chips as they do not have enough resources to handle SSL / Encryption. A bigger board may be possible to do this like the Due or Yun.
here is a link to what I found and also my searching through Google info https://productforums.google.com/forum/#!msg/docs/f4hJKF1OQOw/877WUgNHsUcJ
I will still figure the code for using the SD card locally and how to get it to a computer on the local network. The above link does describe a workaround but you need to subscribe to a third party service and presumably give them some of your credentials to access the forms..
Peter