5.寫入Google試算表(一)

ESP8266端 (TX)

Arduino端(TX)

#include <Wire.h>

#include <LiquidCrystal_I2C.h>

LiquidCrystal_I2C lcd(0x3F,16,2);

/////////////////////////////////////////////////////

#define host "192.168.1.254"

//#define host "10.233.95.178"

#define timing 1000 //建議1000毫秒一組數據

/////////////////////////////////////////////////////

unsigned long t1,t2;

int i=0;

String A,B ;

void lcd_disp(String data1,String data2){

lcd.setCursor(0,0);

lcd.print(" ");

lcd.setCursor(0,0);

lcd.print("A=");

lcd.print(data1);

lcd.print(" B=");

lcd.print(data2);

}

void send_host(){

Serial.print("D");

Serial.print(host);

Serial.print("E");

Serial.flush();

}

void setup() {

Serial.begin(9600);

lcd.init();

lcd.backlight();

lcd.clear();

do{

send_host();

delay(200);

lcd.setCursor(0,1);

lcd.print("waiting...");

}while(!Serial.find("OK"));

lcd.setCursor(0,1);

lcd.print("host ok!");

t1=millis();

}

void loop() {

t2=millis();

if(t2>t1+timing){

A="";

B="";

i++;

A=String(i);

B=String(analogRead(A0));

Serial.print("A");

Serial.print(A);

Serial.print("B");

Serial.print(B);

Serial.print("C");

Serial.flush();

lcd_disp(A,B);

lcd.setCursor(0,1);

lcd.print("Sending Data...");

t1=t2;

}

}

#include <Arduino.h>

#include <ESP8266WiFi.h> // 提供Wi-Fi功能的程式庫

#include <ESP8266HTTPClient.h>

#include <ESP8266WiFiMulti.h>

////////////////////////////

#define SSID "tomorrows"

#define PASSWORD "----"

#define devid "v6275D911F32E961"

////////////////////////////

ESP8266WiFiMulti WiFiMulti;

WiFiServer server(80); // 宣告網站伺服器物件與埠號

const int httpPort = 80;

unsigned long t1,t2;

String cmd, data_A,data_B,host;

int A=0 , B=0 , C=0 , D=0 , E=0;

void data_to_RX(String data3, String data4){

String url = "http://api.pushingbox.com/pushingbox?devid=";

url+=devid;

url+="&data=";

url+=data3;

url+=",";

url+=data4;

// This will send the request to the server

Serial.println(url);

if((WiFiMulti.run() == WL_CONNECTED)) {

HTTPClient http;

http.begin(url);

int httpCode = http.GET();

if(httpCode > 0) {

if(httpCode == HTTP_CODE_OK) {

String payload = http.getString();}

} else {}

http.end(); }}

void rec_cmd(){

cmd="" ;

while(Serial.available()){

char c = Serial.read();

cmd+= c;

delay(10);}

if(cmd.charAt(0)=='A'){

data_A="" , data_B="";

for(int i=0 ; i<cmd.length() ;i++){if(cmd.charAt(i)=='A'){A=i;}}

for(int i=0 ; i<cmd.length() ;i++){if(cmd.charAt(i)=='B'){B=i;}}

for(int i=0 ; i<cmd.length() ;i++){if(cmd.charAt(i)=='C'){C=i;}}

for(int i=A+1 ; i<B ; i++){data_A +=cmd.charAt(i);}

for(int i=B+1 ; i<C ; i++){data_B +=cmd.charAt(i);}

data_to_RX(data_A , data_B);

}

if(cmd.charAt(0)=='D'){

host="";

for(int i=0 ; i<cmd.length() ;i++){if(cmd.charAt(i)=='D'){D=i;}}

for(int i=0 ; i<cmd.length() ;i++){if(cmd.charAt(i)=='E'){E=i;}}

for(int i=D+1 ; i<E ; i++){host +=cmd.charAt(i);}

}

Serial.print("OK");}

void setup() {

Serial.begin(9600);

WiFiMulti.addAP(SSID, PASSWORD);

}

void loop(){

if(Serial.available()){

rec_cmd();}

}