OOOOOOOH BOY IT JUST HIT ME !!!
Looks like you forgot the "DATA" before "DATE" 
Correct syntax is:
Serial.println( (String) "DATA,DATE,TIME," + voltage + "," + degreesC + "," + degreesF );
Perfect! Thank you so much for the help NetDevil!
Thank you so much!
I'm rookie and it's help me a lot!
But there is something I don't know, how to modify the com port in mac office 2016, there is no com port number, in Mac the port only show "/dev/cu.usbmodem1421".
tonypaul57:
But there is something I don't know, how to modify the com port in mac office 2016, there is no com port number, in Mac the port only show "/dev/cu.usbmodem1421".
well ... I don' own a Mac and therefore cannot provide any support for that - but you could maybe try to unhide the settings sheet on Excel (I hid it by default) and manually add your port number in there in the correct cell (will be labeled). Might be that Excel on Mac translates that number to the correct address? Sorry, but that is all I can suggest.
NetDevil:
- show me
Well I hate to advertise for a competitor on your thread, but if you search for Arduino Excel you can see it. Sometimes it's better to take a break and keep testing than to post your problems I guess! Thanks!
@NetDevil, question for you. Since PLX-DAQ takes control of the comport, nothing else can send or receive data while it is connected. Have you considered adding the ability to send data to the Arduino from a text box?
Currently the only way I understand to send data to the attached Arduino is for it to request data from excel. Otherwise there is basically no data going from the PC to the Arduino. This would allow the ability to connect and then send a command from the text box to start/pause/resume/stop data logging (or any other command the user wished to enter into PLX-DAQ that they have programmed in their Arduino sketch).
Hello everyone,
I'm an arduino beginner trying to collect datas from a MPU 6050 sensor to work with excel. I'm using Jeff Rowberg's code and the serial monitor is working correctly. I also managed to make things work with the 2007 version of excel but for some reasons I have to make it work on the 2013 version, (windows 7). Sadly, when I click on the "connect" button on the 2013 excel version, it almost directly stops the arduino working. I was able to determine that with a check led on the arduino.
Do you have an idea what it might be?
Thank you in advance, have a good day!
Antoine
It should work propely,check the Baud-rate and port settings.
@adwsystems: you are right, there is only that one option to send data from PLX DAQ to Arduino. I haven't had any other use case ; yet. Attached you can find a special version of 2.11 with a new text field to send data to Arduino (please expand DirectDebugWindow to fully see the field + button + label). It only works while being connected (obviously ). Give it a try and I might add the same (in beautiful) to the next release. I might add two or three text fields at the same time thus one can post different pre-defined commands more rapidly.
@Toinedrd: never had that kind of issue before. But: during connection establishment PLX DAQ resets the Arduino by default. This can be disabled by unchecking the box "Reset on Connect" on the UI. Keep in mind that you will have your Arduino start in the middle of the loop function, thus no "LABEL" or "CLEARSHEET" written in main function will be read. Also the first data received might be corrupted. But if it works you know your code might be buggy. Did you try with a really simple one like only posting numbers to Serial.println ?
Just a big thankyou it works well.
NetDevil:
@adwsystems: you are right, there is only that one option to send data from PLX DAQ to Arduino. I haven't had any other use case ; yet. Attached you can find a special version of 2.11 with a new text field to send data to Arduino (please expand DirectDebugWindow to fully see the field + button + label). It only works while being connected (obviously
Works Great! I have just the simplest commands setup ('start' and 'end') in the Arduino. I can issue the start command to begin the data log transfer, and end command to stop the transfer. The Arduino does not need to be reset in order to synchronize the start/stop of the transfer and avoids any data corruption due to the port being opened without the reset on connect.
Many thanks NetDevil -- works really well. Appreciated.
Hello everybody. I'm a rookie in the Arduino world and I had a question. I have a pH meter that works perfectly. I want to pass the data to Excel with PLX-DAQ V2. I have been able to name the columns ... etc, but I can not get the pH value out of the pH column. Can you help me? Thank you very much. I leave the code:
String inputstring = "";
String sensorstring = "";
boolean input_string_complete = false;
boolean sensor_string_complete = false;
float sensortring;
int LABEL = 1;
void setup() {
Serial.begin(9600);
Serial3.begin(9600);
Serial.println("CLEARDATA");
Serial.println("LABEL,pH,TIMER");
inputstring.reserve(10);
sensorstring.reserve(30);
}
void serialEvent() {
inputstring = Serial.readStringUntil(13);
input_string_complete = true;
}
void serialEvent3() {
sensorstring = Serial3.readStringUntil(13);
sensor_string_complete = true;
}
void loop() {
if (sensor_string_complete == true) {
Serial.println(sensorstring);
Serial.println((String)"DATA,,TIME");
delay(100);
}
sensorstring = "";
sensor_string_complete = false;
}
Hi miniunder,
Nearly perfect, but you placed the variables in the wrong order for printing. Also you didn't do it in 1 command but in 2.
Correct world be:
if (sensor_string_complete == true) {
Serial.println((String)"DATA," + sensorstring + ",TIME");
delay(100);
}
Notice how the sensorstring now is part of the single serial.println command and how all three commands (data / sensorstring / time) are divided by a comma.
I'm not at my computer thus I wasn't able to test the code, but I think it should work. In case not just post a reply.
Greetings
Yes, it works!!!! Thanks you so much NetDevil!!!!
NetDevil:
Hi miniunder,Nearly perfect, but you placed the variables in the wrong order for printing. Also you didn't do it in 1 command but in 2.
Correct world be:
if (sensor_string_complete == true) {
Serial.println((String)"DATA," + sensorstring + ",TIME");
delay(100);
}
Notice how the sensorstring now is part of the single serial.println command and how all three commands (data / sensorstring / time) are divided by a comma. I'm not at my computer thus I wasn't able to test the code, but I think it should work. In case not just post a reply. Greetings
Hi again, everybody. I wanted to add a K-type thermocouple with MAX 31856 to my program. I included the library in the previous program and added the function to read (or so I think). The case is that the command of the PLX I have not put it well ... can you help me please? I leave the code:
#include <Adafruit_MAX31856.h>
Adafruit_MAX31856 max = Adafruit_MAX31856(10, 11, 12, 13);
String inputstring = "";
String sensorstring = "";
boolean input_string_complete = false;
boolean sensor_string_complete = false;
float sensortring;
int LABEL = 1;
void setup() {
Serial.begin(9600);
Serial3.begin(9600);
Serial.println("CLEARDATA");
Serial.println("LABEL,pH,TEMP,TIMER");
inputstring.reserve(10);
sensorstring.reserve(30);
max.begin();
max.setThermocoupleType(MAX31856_TCTYPE_K);
}
void serialEvent() {
inputstring = Serial.readStringUntil(13);
input_string_complete = true;
}
void serialEvent3() {
sensorstring = Serial3.readStringUntil(13);
sensor_string_complete = true;
}
void loop() {
if (sensor_string_complete == true) {
Serial.println((String)"DATA," + sensorstring + ", + (max.readThermocoupleTemperature) + ,TIME," );
delay(1000);
}
sensorstring = "";
sensor_string_complete = false;
}
Hi miniunder,
well this time I won't help your directly but just point out, that your mistake is, that you included your readThermocoupleTemperature in the string, not as a variable.
Running your code please take a look at the DirectDebugWindow in PLX DAQ and you well see the difference between the sensorstring and the readThermocoupleTemperature both used in your serial.println command 
ok. It works!!! Thanks you so much!!!
Hi Guys,
How can I auto save the spreadsheet when the time is equal to 07:00 AM.
How do you use the tick boxes, can they be used to do a auto save when selected?
Hi Guys,
How do I Auto save the spread sheet when the time is equal to 07:00 AM.
Is that what the tick boxes is for?
How do you use them.
Regards
Bride