Trying to achieve what seemed simple at first (in my rookie's mind). I want to play a sound, and save first 1024 samples from buffer as csv table.

It's sort of works but saved csv is not accurate, the records are messed up chunks, sometimes not starting at the beginning of the file.

I saved my .wav file in audacity as .csv table to have an accurate reference.

I reckon I need some kind of synchronization between beginning of the play() and for loop.

Thank you for your help in advance!

here is the code:

import ddf.minim.*;

Minim minim;
AudioPlayer groove;
AudioMetaData meta;
Table table;

void setup()
{

  minim = new Minim(this);
  groove = minim.loadFile("noise.wav", 1024);
  meta = groove.getMetaData();

  table = new Table();
  table.addColumn("id");
  table.addColumn("data");

  //print some sample info
  println(groove.bufferSize());
  println(meta.sampleFrameCount());


  groove.play();

  for (int i=0; i < groove.bufferSize(); i++) {
    TableRow newRow = table.addRow();
    newRow.setInt("id", table.getRowCount() - 1);
    newRow.setFloat("data", groove.mix.get(i));
  }

  saveTable(table, "data/data.csv");
}

void draw() {
}

Here's my code:

var characterLibrary = new p5.Table();
var input = [];

function setup() {
    createCanvas(1, 1);
    console.log("program started");               
    input = [" ", "!", "\"", "#", "$", "%", "&", "\'", "(", ")", "*", "+", ",", "-", ".", "/", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", ":", ";", "<", "=", ">", "?", "@", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "[", "\\", "]", "^", "_", "`", "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z", "{", "|", "}", "~"];
    characterLibrary.addColumn("index");
    characterLibrary.addColumn("character");
    for(var i = 32; i < input.length + 32; i++) {
        var rowIndex = i-32;
        characterLibrary.addRow();
        characterLibrary.setNum(rowIndex, "index", i);
        characterLibrary.setString(rowIndex, "character", input[i]);
    }
    console.log(millis());
    saveTable(characterLibrary, "characterLibrary.csv");
}

Error I get in chrome:

Uncaught TypeError: Cannot read property 'toString' of undefined
    at p5.TableRow.setString (VM344 p5.js:59736)
    at p5.Table.setString (VM344 p5.js:59407)
    at setup (VM347 generateCharacterLibrary.js:20)
    at p5.<anonymous> (VM344 p5.js:44882)
    at p5.<anonymous> (VM344 p5.js:44810)
    at new p5 (VM344 p5.js:45103)
    at _globalInit (VM344 p5.js:46862)

I've also gotten this error earlier in the day, but went away when I restarted my computer:

VM423 p5.js:59391 Uncaught TypeError: Cannot read property 'setNum' of undefined
    at p5.Table.setNum (VM423 p5.js:59391)
    at setup (VM426 generateCharacterLibrary.js:21)
    at p5.<anonymous> (VM423 p5.js:44882)
    at p5.<anonymous> (VM423 p5.js:44810)
    at new p5 (VM423 p5.js:45103)
    at _globalInit (VM423 p5.js:46862)

Things I've tried:

-console logged all vars, they seem to be performing as expected

-quadruple checked syntax

-tried using simple input array to see if it was a problem with one of my strings

input = ["A", "B", "C"];

-restarted code editor

-tried running html outside code editor

-tried firefox, opera

-restart computer

-switched from p5.js lib on github to build from processing.org

Is something wrong with my code? Or is something up with p5?

"Note: setting maximum row count to 1,310,720 (resize took 1,654 ms)".

This makes my program take ages to run. I added a setRowCount(); line to my code but this did not remedy my issue, it gave me an empty table. Here is my code with the added line:

// stuff is a large array of values > 1 million
t = new Table();
t.setRowCount(10000000);  
t.addColumn("Stuff"); 
for( int i = o; i < stuff.length; i++) 
    {  
    TableRow newRow = t.addRow(); 
    newRow.setFloat("Stuff", stuff[i]);
    } 
saveTable(t, "data.csv");

I have an arduino reading six input values sending them over bluetooth to a PC receiving the data on COM4. The data is coded in the arduino code to have commas seperating the sensor data. I am looking to be able to read the data from the bluetooth and log it in an excel file simultaneously showing the time, date and then the six data values in seperate columns. Can someone help me with this? A code I have started so far is below.

    //import the required libraries
    import processing.serial.*;

    Serial mySerial;
    Table table;
    String filename;

    void setup()
    {
      //set mySerial to listen on COM port 10 at 9600 baud
      mySerial = new Serial(this, "COM4", 9600);

      table = new Table();
      //add a column header "Data" for the collected data
      //add a column header "Time" and "Date" for a timestamp to each data entry
      table.addColumn("Date");
      table.addColumn("Time");
      table.addColumn("Occupancy");
      table.addColumn("Lights");
      table.addColumn("Door");
      table.addColumn("Voltage");
      table.addColumn("WindMPH");
      table.addColumn("Temperature");

    }

    void draw()
    {
      //variables called each time a new data entry is received
      int d = day();
      int m = month();
      int y = year();
      int h = hour();
      int min = minute();
      int s = second();
      float[] data;

      if(mySerial.available() > 0)
      {
        //set the value recieved as a String
        //String value = mySerial.readString();
        String[] value =  loadStrings(mySerial.readString());
        data = float(split(value[0], ','));
        //check to make sure there is a value
        if(value != null)
        {
          //add a new row for each value
          TableRow newRow = table.addRow();
          //place the new row and date under the "Date" column
          newRow.setString("Date", str(d) + "/" + str(m) + "/" + str(y));
          //place the new row and time under the "Time" column
          newRow.setString("Time", str(h) + ":" + str(min) + ":" + str(s));
          //place the new row and value under the "Data" column
          newRow.setString("Occupancy", data[1]);
          newRow.setString("Lights", data[2]);
          newRow.setString("Door", data[3]);
          newRow.setString("Voltage", data[4]);
          newRow.setString("WindMPH", data[5]);
          newRow.setString("TempC", data[6]);



        }
      }
    }

    void keyPressed()
    {
      //variables used for the filename timestamp
      int y = year();
      int d = day();
      int m = month();
      int h = hour();
      int min = minute();
      int s = second();
      //variable as string under the data folder set as (mm-dd--hh-min-s.csv)
      filename = str(m) + "-" + str(d) + "-" + str(y) + "--" + str(h) + "-" + str(min) + "-" + str(s) + ".csv";
      //save as a table in csv format(data/table - data folder name table)
      saveTable(table, filename);
      exit();
    }

import processing.serial.*;
Serial myPort;
Table table;

int numReadings = 100; //8640000 = One day
int readingCounter = 0;

String val;

float y = 0;
float t = 20;


void setup() {
  String portName = Serial.list()[0];

  myPort = new Serial(this, Serial.list()[0], 9600);
  table = new Table();

  table.addColumn("id");
  table.addColumn("month");
  table.addColumn("day");
  table.addColumn("hour");
  table.addColumn("minute");
  table.addColumn("second");

  table.addColumn("sensor1");

  size(1000, 1000);
  frameRate(10);
}

void draw() {

  if ( val != null) {
    y = Float.parseFloat(val);

  } else {
    y = 0;
  }
  rect(t, y, 5, 5);
  t = t + 5;
}

void serialEvent(Serial myPort) {

  try {
    String val = myPort.readStringUntil('\n');
    if (val!= null) {
      val = trim(val);
      println(val, y);  //Control
      float sensorValue[] = float(split(val, ','));

      TableRow newRow = table.addRow();
      newRow.setInt("id", table.lastRowIndex());

      newRow.setInt("month", month());
      newRow.setInt("day", day());
      newRow.setInt("hour", hour());
      newRow.setInt("minute", minute());
      newRow.setInt("second", second());

      newRow.setFloat("sensor1", sensorValue[0]); 
      println(table.lastRowIndex());

      readingCounter++;

      if (readingCounter == numReadings) {
        saveTable(table, "data/new.csv");
      }
    }
  }
  catch(RuntimeException e) {
    e.printStackTrace();
  }
}

In the console comes the following:

    177 0.0
    java.lang.NullPointerException
        at Processing_uebertragung.serialEvent(Processing_uebertragung.java:73)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at processing.serial.Serial.serialEvent(Unknown Source)
        at jssc.SerialPort$EventThread.run(SerialPort.java:1112)
    179 0.0
    0
    181 0.0
    1
    183 0.0
    2
    185 0.0
    3
    186 0.0
    4
    188 0.0
    5
    190 0.0

sorry for my bad english. 8-|

I would like to write a simple program that parses text data from a table and displays a row of text for a specified amount of time. Then I would like for that text to disappear and for the next row to appear for the same time interval.

I experimented with the Bubbles example to see how I would achieve that, but it seems that all the data that are in the table will appear with draw and whatever new bubbles are added through mousePressed will just be timed. I wouldn't like to use the mouse functionality so can anyone help me with achieving a redraw of my sketch so that one bubble appears at a time just based on seconds passed. Thank you, here's my code:

Table table;
Bubble[] bubbles;
void setup() {
  size(480, 360);
  loadData();
  frameRate(1);
}
void draw() {
  background(255);
 drawWords(frameCount);
}
void drawWords(int count){
  // add code year to draw some words based on the number given in 'count'
   for (int i = 0; i<bubbles.length; i++) {
    bubbles[i].display();

  }
}
void loadData() {
  // "header" indicates the file has header row. The size of the array 
  // is then determined by the number of rows in the table. 
  table = loadTable("data.csv", "header");
  bubbles = new Bubble[table.getRowCount()];
  for (int i = 0; i<table.getRowCount(); i++) {
    // Iterate over all the rows in a table.
    TableRow row = table.getRow(i);
   // Access the fields via their column name (or index).
    float x = row.getFloat("x");
    float y = row.getFloat("y");
    float d = row.getFloat("diameter");
    String n = row.getString("name");
    // Make a Bubble object out of the data from each row.
    bubbles[i] = new Bubble(x, y, d, n);
  }
}
void mousePressed() {
  // When the mouse is pressed, create a new row and set the values for each column of that row.
  TableRow row = table.addRow();
  row.setFloat("x", mouseX);
  row.setFloat("y", mouseY);
  row.setFloat("diameter", random(40, 80));
  row.setString("name", "Blah");
// If the table has more than 10 rows, delete the oldest row.
  // This writes the table back to the original CSV file
  // and reloads the file so that what's drawn matches.
  saveTable(table, "data/data.csv");
  loadData();
}
// This simple Bubble class draws a circle to the window 
// and displays a text label when the mouse hovers.
class Bubble {
  float x, y;
  float diameter;
  String name;
  boolean over = false;
  // Create the Bubble
  Bubble(float tempX, float tempY, float tempD, String s) {
    x = tempX;
    y = tempY;
    diameter = tempD;
    name = s;
  }
  // Checking if mouse is over the bubble
  void rollover(float px, float py) {
    float d = dist(px, py, x, y);
    if (d<diameter/2) {
      over = true; 
    } else {
      over = false;
    }
  }
  // Display the Bubble
  void display() {
    stroke(0);
    strokeWeight(2);
    noFill();
    ellipse(x, y, diameter, diameter);
      fill(0);
      textAlign(CENTER);
      text(name, x, y+diameter/2+20);
  }
}
//Ends Here

import controlP5.*; Table table; ControlP5 cp5;

int col = color(255); controlP5.Toggle b;

boolean setVisible=true; int inside = -1; int x1= 0;

void setup() { size(400,400); smooth();

table = new Table();

cp5 = new ControlP5(this); table.addColumn("kapcsolo1",Table.INT);

TableRow newRow = table.addRow(); newRow.setInt("kapcsolo1", x1);

saveTable(table, "data/new.csv"); // create a toggle and change the default look to a (on/off) switch look b = cp5.addToggle("toggle") .setPosition(40,250) .setSize(50,20) .setValue(true) .setMode(ControlP5.SWITCH) .setVisible(true) ;

}

void draw() { background(0);

pushMatrix();

translate(280,100); if(inside==1) ellipse(0,0,100,100);

popMatrix(); }

void toggle(boolean theFlag) { if(theFlag==true) { inside=inside-1; x1=1; } else { inside=inside-1; x1=0; } }

In my program im using several variables and I want to save them to txt file or excel file. After that I will make some graphs with them in other program. http://scr.hu/5o3i/35y8h here is my variables. I know how to show them in console by println but idk how to save them. Saw saveTable and saveStrings but i dont know how to use them to my program.

thx for help

I copied/pasted this sketch from the processing site tutorial : https://processing.org/reference/Table.html

void setup() {

  table = new Table();

  table.addColumn("id");
  table.addColumn("species");
  table.addColumn("name");

  TableRow newRow = table.addRow();
  newRow.setInt("id", table.lastRowIndex());
  newRow.setString("species", "Panthera leo");
  newRow.setString("name", "Lion");

  saveTable(table, "data/new.csv");
}

// Sketch saves the following to a file called "new.csv":
// id,species,name
// 0,Panthera leo,Lion

It gives me the following error message "The variable "Table" does not exist".

Sorry if the question is too stupid! :) Thanks in advance

When I print out the table I get 'processing.data.Table@66ede931', giving me proof that the table is really there!, so the bug must be the in the path?

import processing.core.PApplet;
import processing.data.Table;
import processing.data.TableRow;    

public class WriteCsv {

    static PApplet parent;

    public WriteCsv(PApplet p) {
        parent = p;
    }

    Table table;

    public void createNewCsv() {

       table.addColumn("M_Phase");//342
       table.setInt(1, "M_Phase", 0);//342

       parent.println("table : " + table  ); // prints out 'processing.data.Table@66ede931', so table is not a null!!
       parent.saveTable( table, "data/info.csv" );
}
}

Any ideas what can cause the this error?

I'm currently using Arduino to control an LED-strip (as semicircle) of 180 LEDs with an Arduino Uno board. My Arduino sketch has the following process operation: The LEDs are blinking one after another and start with a frequency of 50Hz and go down to 20 Hz before they switch forward. In addition to that, there is a button which can be pressed for instant switching, whereby the frequency and the respective LED-number are send over a serial port, so you can see them in the serial Monitor (Arduino).

Now I would like to save these data on my PC with help of Processing. I know that there are many tutorials and articles to find but I only found Processing-codes to save sensorsinput. I guess there is a simple the solution, but I'm a total greenhorn in programming (especially Processing) and would like an opinion about my current "work" (I don't even know if my code is even sligthly correct :D)

And of course my crappy (sorry for vile language^^) Processing sketch: Note that the framework is from codes I found in other posts!

import processing.data.Table;
import processing.serial.*;


Serial myPort; //creates a software serial port
Table dataTable; //table to store values.

int numReadings = 500; //keeps track of how many readings one would like to take before writing the file. 
int readingCounter = 0; //counts each reading to compare to numReadings. 
float Winkel;
String Wink;



String fileName;
void setup()
{
  String portName = Serial.list()[0]; 

  myPort = new Serial(this, portName, 9600); //set up your port to listen to the serial port

  dataTable = new Table();
  dataTable.addColumn("id"); //This column stores a unique identifier for each record. We will just count up from 0 - so the first reading will be ID 0, the second will be ID 1, etc. 

  //the following adds columns for time.
  dataTable.addColumn("year");
  dataTable.addColumn("month");
  dataTable.addColumn("day");
  dataTable.addColumn("hour");
  dataTable.addColumn("minute");
  dataTable.addColumn("second");

  //columns for values
  dataTable.addColumn("Winkel");
  dataTable.addColumn("Frequenz");
}

  void draw() { 
    TableRow newRow = dataTable.addRow(); //add a row for this new reading
    newRow.setInt("id", dataTable.lastRowIndex());//record a unique identifier (the row's index)

    Wink = myPort.readString();
    println(Winkel);

    //record time stamp
    newRow.setInt("year", year());
    newRow.setInt("month", month());
    newRow.setInt("day", day());
    newRow.setInt("hour", hour());
    newRow.setInt("minute", minute());
    newRow.setInt("second", second());

    //record information. 
    newRow.setFloat("Winkel", Winkel);


    readingCounter++; //optional, use if you'd like to write your file every numReadings reading cycles

    //saves the table as a csv in the same folder as the sketch every numReadings. 
    if (readingCounter % numReadings ==0)//The % is a modulus, a math operator that signifies remainder after division. The if statement checks if readingCounter is a multiple of numReadings (the remainder of readingCounter/numReadings is 0)
    {
      fileName = str(year()) + str(month()) + str(day()) + str(dataTable.lastRowIndex()); //filename: year+month+day+readingCounter
      saveTable(dataTable, fileName); // save it to computer.
    }
}

The idea here is just to get the frequency (in German: Frequenz) and angle (in German: Winkel) data in a file. It doesn't have to look fancy. I do hope that I provided you with every necessary information! I can also add a screenshot of the serial monitor from Arduino by request.

Many thanks in advance for your help!

This is my processing code:

import processing.serial.*;
Serial myPort;

Table table;

int val;
int numReadings = 10; 
int readingCounter = 0;

void setup() {
 String portName = Serial.list()[0];
 myPort = new Serial(this, portName, 9600);

  table = new Table();

  table.addColumn("id");
  table.addColumn("minute");
  table.addColumn("second");
  table.addColumn("wert");


}

void draw() {

  val = myPort.read();
  println(val);

      TableRow newRow = table.addRow();
  newRow.setInt("id", table.lastRowIndex());
  newRow.setInt("minute", minute());
  newRow.setInt("second",second());
  newRow.setInt("wert", val);

  readingCounter++;

 if (readingCounter % numReadings ==0)
 {
   saveTable(table, "data/new8.csv");
 }
}

it should simply print: number of table row, minute, second, 20

but it prints:

88,37,58,50

89,37,58,48

90,37,58,13

91,37,58,10

92,37,58,-1

93,37,58,-1

94,37,58,50

95,37,58,48

96,37,58,13

97,37,58,10

98,37,58,-1

99,37,58,-1 and so on...

why does it show 50 then 48 then 13 then 10 and then two times -1? And how can I convert that to the original integer number 20?

I tried this:

 val = myPort.readString();
 newRow.setString("wert", val);

but then the value 20 is only in the last row of the excel file. In all other rows only row id, minute and seconds are printed. Like this:

82,8,58,

83,8,58,

84,8,58,

85,8,59,

86,8,59,

87,8,59,"20

//this is what new.csv looks like.
//id, species
//1, a
//2, b
//3, c
//4, d
//5, e <----- this row is what I want to add

and here is my code:

var table;
function preload() { 
  table = loadTable("new.csv", "csv", "header");
}
function setup() {
  var newRow = table.addRow();
  newRow.setString("id", 5);
  newRow.setString("species", "e");
  for (var r = 0; r < table.getRowCount(); r++) {
    for (var c = 0; c < table.getColumnCount(); c++) {
      println(table.getString(r, c));
    }
  }
  saveTable(table, 'new.csv');
}

The row is properly added when I println(table.getString(r, c)); but not in replaced new.csv file. I tried to save it with different file name as new1.csv but still doesn't work. Could you fix this problem for me? Thank you.

I had done it successfully save to the right table. However, if users restart second times, the data of the second time will save in the wrong place and so on!

You can see that there is a blank about 10 rows in the B column.... I have no idea how to deal with this problem...

The code that I had written.....

void mousePressed() {

 if (mouseX > startBtnX && mouseX < startBtnX+startBtnW && mouseY > startBtnY && mouseY < startBtnY+startBtnH) {
   buttonPressed = true;
 }

 if (mouseButton == LEFT) { 
   println("timer started");
   mouseClicks++; 
   sw = new StopWatchTimer();
   sw.start();//store the current time 
  }

 if (mouseClicks == limit) { 
    saveTable(table, "data/data.csv");
    table.addColumn("id");
    sw.reset();
    mouseClicks = 0;
    //output.close();
    buttonPressed = false;

  }  

class StopWatchTimer {

TableRow newRow = table.addRow(); float ct = (currentTime/1000); String nct = ""+ct;

void start() { currentTime = millis() - startTime; println((currentTime/1000)-1); newRow.setString("id",nct);

} void reset() { currentTime = 0; startTime = millis(); println("timer started");

} }

Table table;
int counter=0;

void setup() {
  size(); 
  table= new Table();
  table.addColumn("id", Table.INT);
  table.addColumn("valueX", Table.INT);
  table.addColumn("valueY", Table.INT);
  saveTable(table, "data/new.csv");
}


void draw() {
  TableRow row=table.addRow();
  row.setInt("id", counter);
  row.setInt("valueX", mouseX);
  row.setInt("valueY", mouseY);

  counter++;



  //if (table.getRow()>10) {
  //  table.removeRow(0);


  //}
}

void mousePressed() {
  exit();
}

**tl;dr **

Is there a way that I can modify the processing code to filter just the seconds of the reaction time instead of every line that comes from the serial?

Below there are 3 blocks of code:

1) the arduino code that i want to implement,

2) the processing code,

3) and the original arduino code meant for the processing code.

Arduino code so far:

(more readable pastebin here http://pastebin.com/Ej6jt6RZ)

 /* REACTION TIME (with 2 leds) v1.1
  *  Luis Andrés Gonzalez
  * Reaction time original version from http://www.instructables.com/id/Arduino-Reaction-Time-Tester/?ALLSTEPS
  * Send data to processing via the Serial Port original from By Elaine Laguerta http://url/of/online/tutorial.cc
 */
 int switchPin = 6;  // pin where the button will be connected
 int ledPin1 = 2 ;   // LED that signals starting of the game
 int ledPin2 = 8 ;   // LED that lights to test the reaction time
 
 // declare some variables:
 boolean lastButton = LOW;
 boolean currentButton = LOW;
 boolean Started = false;
 boolean timer = false;
 long startTime;
 long endTime;
 int randomTime;
 long beginTime;
 float elapsedTime;
 
 
 void setup()
 {
   // Setup button and LEDs:
   pinMode(switchPin, INPUT);
   pinMode(ledPin1, OUTPUT);
   pinMode(ledPin2, OUTPUT);
 
   // Begin serial communication
   Serial.begin(9600);
 }
 boolean debounce(boolean last)
 {
   boolean current = digitalRead(switchPin);
   if(last != current)
   {
     delay(5);
     current = digitalRead(switchPin);
   }
   return current;
 }
 
 
 void loop()
 {
   // see if button pressed
   currentButton = debounce(lastButton);
   if(lastButton == LOW && currentButton == HIGH)
   {
     if(Started==false){
       Started=true;
       randomTime = random(4,10);
       randomTime = randomTime*1000;
       Blink();
       beginTime=millis(); 
       
     }
     else{
       if((millis()-beginTime)>=randomTime){
           Stop();
           Started=false; 
           timer=false;         
       }
       
       else{
         Started=false;
         timer=false;
         Serial.println("You pressed the button too soon !");
         for(int i=0; i<3; i++){
           Blink();
         }
       }
     }
   }
      
   lastButton = currentButton;
   
   if(Started == true && (millis()-beginTime)>=randomTime && timer==false){
     Serial.println("Start");
     timer=true;
     Start();
   }
 }
   
 
 
 
 
 
 void Start(){
   startTime = millis();
   digitalWrite(ledPin1, HIGH);
 }
 
 void Blink(){
   digitalWrite(ledPin2, HIGH);
   delay(100);
   digitalWrite(ledPin2, LOW);
   delay(100);
 }
 
 void Stop(){
   endTime = millis();
   elapsedTime = (endTime - startTime)+5;
   elapsedTime = elapsedTime/1000;
   Serial.print("Time Seconds: ");
   Serial.println(elapsedTime);
   digitalWrite(ledPin1, LOW);
    
 }

Processing code:

(http://pastebin.com/EjEcuqct)

 
 /* 
   Saving Values from Arduino to a .csv File Using Processing - Pseduocode
 
   This sketch provides a basic framework to read data from Arduino over the serial port and save it to .csv file on your computer.
   The .csv file will be saved in the same folder as your Processing sketch.
   This sketch takes advantage of Processing 2.0's built-in Table class.
   This sketch assumes that values read by Arduino are separated by commas, and each Arduino reading is separated by a newline character.
   Each reading will have it's own row and timestamp in the resulting csv file. This sketch will write a new file a set number of times. Each file will contain all records from the beginning of the sketch's run.  
   This sketch pseduo-code only. Comments will direct you to places where you should customize the code.
   This is a beginning level sketch.
 
   The hardware:
   * Sensors connected to Arduino input pins
   * Arduino connected to computer via USB cord
         
   The software:
   *Arduino programmer
   *Processing (download the Processing software here: https://www.processing.org/download/
   *Download the Software Serial library from here: http://arduino.cc/en/Reference/softwareSerial
 
   Created 12 November 2014
   By Elaine Laguerta
   http://url/of/online/tutorial.cc
 
 */
 
 import processing.serial.*;
 Serial myPort; //creates a software serial port on which you will listen to Arduino
 Table table; //table where we will read in and store values. You can name it something more creative!
 
 int numReadings = 5; //keeps track of how many readings you'd like to take before writing the file. 
 int readingCounter = 0; //counts each reading to compare to numReadings. 
  
 String fileName;
 void setup()
 {
   String portName = Serial.list()[1]; 
   //CAUTION: your Arduino port number is probably different! Mine happened to be 1. Use a "handshake" sketch to figure out and test which port number your Arduino is talking on. A "handshake" establishes that Arduino and Processing are listening/talking on the same port.
   //Here's a link to a basic handshake tutorial: https://processing.org/tutorials/overview/
   
   myPort = new Serial(this, portName, 9600); //set up your port to listen to the serial port
   table = new Table(); 
   table.addColumn("id"); //This column stores a unique identifier for each record. We will just count up from 0 - so your first reading will be ID 0, your second will be ID 1, etc. 
   
   //the following adds columns for time. You can also add milliseconds. See the Time/Date functions for Processing: https://www.processing.org/reference/ 
   table.addColumn("year");
   table.addColumn("month");
   table.addColumn("day");
   table.addColumn("hour");
   table.addColumn("minute");
   table.addColumn("second");
   
   //the following are dummy columns for each data value. Add as many columns as you have data values. Customize the names as needed. Make sure they are in the same order as the order that Arduino is sending them!
   table.addColumn("sensor1");  
 
 }
 
 void serialEvent(Serial myPort){
   String val = myPort.readStringUntil('\n'); //The newline separator separates each Arduino loop. We will parse the data by each newline separator. 
   if (val!= null) { //We have a reading! Record it.
     val = trim(val); //gets rid of any whitespace or Unicode nonbreakable space
     println(val); //Optional, useful for debugging. If you see this, you know data is being sent. Delete if  you like. 
     int sensorVals = int(val); //parses the packet from Arduino and places the valeus into the sensorVals array. I am assuming floats. Change the data type to match the datatype coming from Arduino. 
    
     TableRow newRow = table.addRow(); //add a row for this new reading
     newRow.setInt("id", table.lastRowIndex());//record a unique identifier (the row's index)
     
     //record time stamp
     newRow.setInt("year", year());
     newRow.setInt("month", month());
     newRow.setInt("day", day());
     newRow.setInt("hour", hour());
     newRow.setInt("minute", minute());
     newRow.setInt("second", second());
     
     //record sensor information. Customize the names so they match your sensor column names. 
     newRow.setInt("sensor1", sensorVals);
     
     
     readingCounter++; //optional, use if you'd like to write your file every numReadings reading cycles
     
     //saves the table as a csv in the same folder as the sketch every numReadings. 
     if (readingCounter % numReadings ==0)//The % is a modulus, a math operator that signifies remainder after division. The if statement checks if readingCounter is a multiple of numReadings (the remainder of readingCounter/numReadings is 0)
     {
       //saveTable(table, "data/new.csv");
       fileName = "data/" + str(year()) + str(month()) + str(day()) + str(table.lastRowIndex()) + ".csv"; //this filename is of the form year+month+day+readingCounter
       saveTable(table, fileName); //Woo! save it to your computer. It is ready for all your spreadsheet dreams. 
     }
    }
 }
 
 void draw()
 { 
    //visualize your sensor data in real time here! In the future we hope to add some cool and useful graphic displays that can be tuned to different ranges of values. 
 }

The original Arduino code meant for the processing code above:

(http://pastebin.com/qQF7YbYN)

/*
Sending Data to Processing via the Serial Port
This sketch provides a basic framework to send data from Arduino to Processing over a Serial Port. This is a beginning level sketch.

Hardware:
* Sensors connected to Arduino input pins
* Arduino connected to computer via USB cord

Software:
*Arduino programmer
*Processing (download the Processing software here: https://www.processing.org/download/

Additional Libraries:
*Read about the Software Serial library here: http://arduino.cc/en/Reference/softwareSerial

Created 12 November 2014
By Elaine Laguerta
http://url/of/online/tutorial.cc
*/

/*To avoid overloading the Arduino memory, and to encourage portability to smaller microprocessors, this sketch
does not timestamp or transform data. In this tutorial, timestamping data is handled on the processing side.

Whether you process data on the Arduino side is up to you. Given memory limitations of the Arduino, even a few computations and mapping of values can
max out the memory and fail. I recommend doing as little as possible on the Arduino board.*/

//#include SoftwareSerial.h

/*Declare your sensor pins as variables. I'm using Analog In pins 0 and 1. Change the names and numbers as needed
Pro tip: If you're pressed for memory, use #define to declare your sensor pins without using any memory. Just be careful that your pin name shows up NOWHERE ELSE in your sketch!
for more info, see: http://arduino.cc/en/Reference/Define
*/
int sensor1Pin = 6;


/*Create an array to store sensor values. I'm using floats. Floats use 4 bytes to represent numbers in exponential notation. Use int if you are representing whole numbers from -32,768 to 32,767.
For more info on the appropriate data type for your sensor values, check out the language reference on data type: http://arduino.cc/en/Reference/HomePage
Customize the array's size to be equal to your number of sensors.
*/
/*
 * Prueba de dejar esto afuera
 float sensorVals[] = {0,0,0}
*/
/*Pro tip: if you have a larger number of sensors, you can use a for loop to initialize your sensor value array. Here's sample code (assuming you have 6 sensor values):
float sensorVals[6];
int i;
for (i=0; i<6; i++)
{
sensorVals[i] = 0;
}
*/

void setup(){
Serial.begin(9600); //This line tells the Serial port to begin communicating at 9600 bauds
}

//
void loop(){
//read each sensor value. We are assuming analog values. Customize as nessary to read all of your sensor values into the array. Remember to replace "sensor1Pin" and "sensor2Pin" with your actual pin names from above!
int sensorVal = digitalRead(sensor1Pin);

/*If you are reading digital values, use digitalRead() instead. Here's an example:
sensorVal[0] = digitalRead(sensor1Pin);
*/

//print over the serial line to send to Processing. To work with the processisng sketch we provide, follow this easy convention: separate each sensor value with a comma, and separate each cycle of loop with a newline character.
//Remember to separate each sensor value with a comma. Print every value and comma using Serial.print(), except the last sensor value. For the last sensor value, use Serial.println()
//Serial.print(sensors[0]);
//Serial.print(",");
//Serial.print(sensors[1]);
//Serial.print(",");
Serial.println(sensorVal);
delay(1000);
}

My code looks like this:

int hammerArDatRaw[] = {
  2000, 2100, 2200, 2300, 3000, 4000, 3000
};

Table table;
TableRow row;

String nameOfExperiment = "Experiment";
int numberOfStrokeSaved = 0;



void setup() {
  table = new Table();
  WriteDataToCSVFile(hammerArDatRaw, "kkk");
  WriteDataToCSVFile(hammerArDatRaw, "skr");
  makeCSVFile(nameOfExperiment);
}

void makeCSVFile(String name) {
  saveTable(table, "data/"+nameOfExperiment+".csv");
}

void WriteDataToCSVFile(int array[], String nameOfData) {
  table.addColumn(nameOfData, Table.INT);
  row = table.addRow();


  for (int i = 0; i< array.length; i++) {
    row.setInt(nameOfData, array[i]);
    row = table.addRow();
  }
}

As one can if they open the CSV file it looks like this:

kkk skr 2000 0 2100 0 2200 0 2300 0 3000 0 4000 0 3000 0 0 0 0 2000 0 2100 0 2200 0 2300 0 3000 0 4000 0 3000 0 0

(Okay the quote system turned the columns sideways, so flip it 90 deg and you see my problem).

I don't want the zeroes but want the data to begin from the top everytime i call WriteDataToCSVFile(). What am i doing wrong?

, "Typ Schloss Stck. ","Schliess Nr. ","Nr ","Schluessel Stck ",Hauptschluessel Anzahl 1 0102- 1 2 6667 X,,,,, 1 0104- 2 2 6667 X,,,,, 1 0120- 3 2 6667 X,,,,, 1 0122- 4 2 6667 X,,,,, 1 0124- 5 2 6667 X,,,,, 1 0140- 6 2 6667 X,,,,, 1 0142- 7 2 6667 X,,,,, 1 0144- 8 2 6667 X,,,,, 1 0300- 9 2 6667 X,,,,, 1 0302- 10 2 6667 X,,,,, 1 0304- 11 2 6667 X,,,,, 1 0320- 12 2 6667 X,,,,, 1 0322- 13 2 6667 X,,,,, 1 0324- 14 2 6667 X,,,,, 1 0340- 15 2 6667 X,,,,, 1 0342- 16 2 6667 X,,,,, 1 0344- 17 2 6667 X,,,,, 1 2100- 18 2 6667 X,,,,, 1 2102- 19 2 6667 X,,,,, 1 2104- 20 2 6667 X,,,,, der Code sieht so aus:

`void excel() { // func start

 Table table;
 String l1="    ";
 String l2="Typ Schloss Stck.    ";
 String l3="Schliess Nr.     ";
 String l4="Nr    ";
 String l5="Schluessel Stck      ";
 String l6="Hauptschluessel  Anzahl";



  table = new Table();  

  table.addColumn(l1);
  table.addColumn(l2);
  table.addColumn(l3);
  table.addColumn(l4);
  table.addColumn(l5);
  table.addColumn(l6);

  for (int x=0; x<AT5; x++){    
  TableRow newRow = table.addRow();
  newRow.setString(0,zeilen[x]);  
  saveTable(table, "Kunden/"+kdnr+" excel kompl.csv"); 
  }

  for (int xx=0; xx<zzz; xx++){    
  TableRow newRow = table.addRow(); 
  newRow.setString(0,folge1[xx]);  
  saveTable(table, "Kunden/"+kdnr+" excel folge.csv");
  datenspeicher();
  }

} // func ende`