Task to be acomplished:
I wish to upload data being logged onto an SD card to a windows based machine and then process this data in EXCEL 2010.
The catch is, I would like to do this via internet with the data being available anywhere with internet access and by someone using EXCEL 2010.
I have tried temboo and ThingSpeak but I am wondering if there is a simple way to generate and host a webpage on the Yun that will allow EXCEL 2010 to perform a web query without any third party steps?
What I have tried:
Running the TemperatureWebPanel example with a modified sketch to give a table of values (see code below) and then accessing this web page on my local wifi network.
*/
#include <Bridge.h>
#include <BridgeServer.h>
#include <BridgeClient.h>
// Listen on default port 5555, the webserver on the Yún
// will forward there all the HTTP requests for us.
BridgeServer server;
String startString;
long hits = 0;
void setup() {
SerialUSB.begin(9600);
// Bridge startup
pinMode(13, OUTPUT);
digitalWrite(13, LOW);
Bridge.begin();
digitalWrite(13, HIGH);
// using A0 and A2 as vcc and gnd for the TMP36 sensor:
pinMode(A0, OUTPUT);
pinMode(A2, OUTPUT);
digitalWrite(A0, HIGH);
digitalWrite(A2, LOW);
// Listen for incoming connection only from localhost
// (no one from the external network could connect)
server.listenOnLocalhost();
server.begin();
// get the time that this sketch started:
Process startTime;
startTime.runShellCommand("date");
while (startTime.available()) {
char c = startTime.read();
startString += c;
}
}
void loop() {
// Get clients coming from server
BridgeClient client = server.accept();
// There is a new client?
if (client) {
// read the command
String command = client.readString();
command.trim(); //kill whitespace
SerialUSB.println(command);
// is "temperature" command?
if (command == "temperature") {
// get the time from the server:
Process time;
time.runShellCommand("date");
String timeString = "";
while (time.available()) {
char c = time.read();
timeString += c;
}
//SerialUSB.println(timeString);
client.print("<table>");
client.print('\n');
client.print("</tbody>");
client.print('\n');
//------------------------------------------------------------------------------
for(int count=0;count<10;count++)
{
Process time;
time.runShellCommand("date");
String timeString = "";
while (time.available())
{
char c = time.read();
if (c != '\n')
{
timeString += c;
}
}
int sensorValue = analogRead(A1);
// convert the reading to millivolts:
float voltage = sensorValue * (5000.0f / 1024.0f);
// convert the millivolts to temperature celsius:
float temperature = (voltage - 500.0f) / 10.0f;
// print the temperature:
client.print("<tr>");
client.print("<td>");
client.print(timeString);
client.print("</td>");
//client.print("
Current temperature: ");
client.print("<td>");
client.print(temperature);
client.print("</td>");
client.print("<td>");
client.print('\n');
client.print("</td>");
client.print("</tr>");
//client.println(" °C");
/*client.print("
This sketch has been running since ");
client.print(startString);
client.print("
Hits so far: ");
client.print(hits);
*/
delay(1000);
}
//-----------------------------------------------------------------------
client.print('\n');
client.print("</tbody>");
client.print('\n');
client.print("</table>");
}
// Close connection and free resources.
client.stop();
hits++;
}
delay(1000); // Poll every sec
}
The problem is that when trying to create the web query in EXCEL, I get an error message....
Unable to get property 'getComputedStyle' of undefined or null reference.
Code 0
URL http://192.168.1.64/sd/TemperatureWebPanel/zepto.min.js
I can see only a single '0' character in the web query setup wizard and the excel sheet displays this after a message saying 'TemperatureWebPanel' getting data appears in the selected cell for the data import.
I have directed the web query wizard to both the
http://arduino.local/sd/TemperatureWebPanel/ and the form that uses the IP address for the Yun.
I have almost no experience with Javascript and HTML and I guess it is probably this that is leading to failure. I have spent hours trawling web pages trying to find a simple instruction on how to set-up a web page that will allow using the web query setup wizard from EXCEL or an IQY file to access the data on the page.
Your help on this would be much appreciated. I guess there are others in the community who want to get tables of data from their Arduino remotely.