How to set multiple columns of different variables using Data Streamer add-in on Excell?

[tuesday_j]

I need some help to set up the data into Excel using Data Streamer add-in:

I wrote this on Arduino IDE:

Serial.println(force);
Serial.print(",");
Serial.println(ROM);
Serial.print(",");
Serial.println(count);
Serial.print(",");
Serial.println(ROMcounter);
Serial.print(",");
Serial.println(frqz);
Serial.print(",");
Serial.println(FtR);
Serial.print(",");
Serial.println();

...where force, ROM, frqz, and FtR have been declared as "float". and count and ROMcounter as "int" (because they are counters). I haven't been able to set all these 6 variables in different columns. Only the variable force appears on the first column and the rest of the variables in the second one, all 5 variables one below the other.

I am using only 2 sensors (a potentiometer and a force-sensitive resistor). The rest of the variables (4 variables) are calculation in the Arduino (Arduino UNO R3); frequency, time, force to ROM ratio, etc.

Here some screenshot of what I am getting on Excell:

Here two guides I used (but I am still stoked at the column set up):

☒ Using Execl Data Streamer to show data from xChips

[chrisknightley]

I haven't used or seen the that library, but as far as I can see the image provided, it looks like the nomally line breaks are still applied.
That is, it is new-line by println, so you should use "println" only at the end of one line of data and "print" for the rest.

[tuesday_j]

I tried that before but I couldn't make it work. I restarted everything and tried that again and boom, all variables appeared in different columns.

Thanks, @chrisknightley !!