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?
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
sir i have to access the data through internet from a remomte location..one end pc and anther end seensor with arduino..
Sounds like you need an Ethernet shield and leverage the SD card on it for data logging
now using a simple browser of other client you can reach out to the device and download the logs
do you have an internet connection available where the arduino is going to be located ? (Silly me, of course you do, otherwise Google+ would not be an option)
Peter
ye i have sir..my requirement is i need to store the sensor data in a pc which is located in a remote location..to store it in a sequence like excel sheet...
peter oaks sir am very much happy with ur replies u r helping me a lot..actually i tried the thing pushing box but have few doubts i need some guidance can u hep me sir via skype or teamviewer..
I have never used it myself, I simply found it while researching your problem and also a friend of mine had been using one similar
he is actually using this https://temboo.com/ and seems to think it is pretty good
either way you need to give the service your username and password to the google+ account
Personally I would have an Ethernet of WIFI shield on the Arduino and access it over the internet directly from my PC. Saving intermediate values to an SD card then streaming the data to the PC on demand