Soo did some more searching and found this tutorial:
https://code.google.com/p/my-arduino-lessons/wiki/Excel_Interface
It has some simple code.
int val = 0;
int val1 = 0;
void setup() {
Serial.begin(9600); // opens serial port, sets data rate to 9600 bps
// int val = 0;
Serial.println("CLEARDATA"); // clear data in excel
}
void loop()
{
Serial.print("DATA,TIME,"); // send comand to excel
Serial.println(val1); // send data
val1 = random(0, 100); // random bet 0 and 100
delay(3000);
}
About as simple as it gets.
Pretty much confirms the commands
I verify then download and in the Arduino serial monitor I can see CLEARDATA and DATA, TIME along with the random numbers generated.
In the excel/ PLX spreadsheet controller messages it says Accepting data for row 1, Accepting data for Row 2, etc.
The letters are doing the same thing.
but no data shows up in the excel boxes.
Doing the same thing my program is doing wrong.
... OK I opened a new "book" without the graph.
Clicked file in the upper left and clicked new.
A window with "workbook" showed up. I clicked OK and a new window/sheet showed up.
It has tabs for sheet 1, sheet 2, sheet 3 at the lower left.
I can see data loading into the squares now.
The PLX-DAQ spreadsheet I've been having problems with has "simple data", simple data with plots, and interactive bar graph tabs at the bottom left.
Trying my program on the fresh workbook and it doesn't work until I change this line:
Serial.print(sensors.getTempFByIndex(0));
to:
Serial.println(sensors.getTempFByIndex(0));
Now data shows up in column B, while the LABEL temp sits over column A which contains a bunch of####### in each box.
sooo some progress, I'll figure out more and post it.
Any tips appreciated.