I posted this in a thread with similar information so all the info could be found in one post buuut...
so here's a link to that post:
http://forum.arduino.cc/index.php?topic=132123.0
Alot more going on there than sending data to excel right?
The LCD stuff doesn't have anything to do with graphing in excel right?
I'm having the same problem as the original poster C is green, R flashes, solid green T no red transmit pulse.
According to the info linked to here:
Commands that talk to excel are always in CAPITAL letters.
DATE, TIME that allows the serial port to send data to Excel. The first field is always TIME, then the fields of interest (val). The command format is: Serial. print (“DATE, TIME,”); Serial.println (val)
It needs a line that says DATE TIME probably a mispprint that was supposed to say DATA, TIME because all the sample programs use that.
I have that. Somehow it allows the serial port to send data to excel, it can't send data without that line.
LABEL sends the column headings.
I have that but I never get any labels to show up, even though it says setting labels in the connected/disconnected box in the spreadsheet after I hit connect.
Here's my code:
/*-----( Import needed libraries )-----*/
#include <OneWire.h>
#include <DallasTemperature.h>
/*-----( Declare Constants )-----*/
#define ONE_WIRE_BUS 2 /*-(Connect to Pin 2 )-*/
/*-----( Declare objects )-----*/
/* Set up a oneWire instance to communicate with any OneWire device*/
OneWire ourWire(ONE_WIRE_BUS);
/* Tell Dallas Temperature Library to use oneWire Library */
DallasTemperature sensors(&ourWire);
/*-----( Declare Variables )-----*/
int row = 0;
int x;
void setup() /*----( SETUP: RUNS ONCE )----*/
{
Serial.begin(9600);
Serial.println("CLEARDATA");
Serial.println("LABEL, Temp");
/*-( Start up the DallasTemperature library )-*/
sensors.begin();
}/*--(end setup )---*/
void loop() /*----( LOOP: RUNS CONSTANTLY )----*/
{
Serial.print("DATA,TIME,"); Serial.print(sensors.getTempFByIndex(0));
sensors.requestTemperatures(); // Send the command to get temperatures
row++;
x++;
if (row > 360)
{
Serial.print(sensors.getTempFByIndex(0));
Serial.println("ROW,SET,row");
}
Serial.print(sensors.getTempCByIndex(0));
Serial.print(sensors.getTempFByIndex(0));
delay(10000);
}
/* --(end main loop )-- */
/* ( THE END ) */
Sooo what am I doing wrong?