Reading my excel data in Processing

[Chrisir]

You can export/ save as in Excel.

Save as csv text file

This file you can copy into your Sketch folder.

Then loadStrings or loadTable

Can't form array using splitText method (loadStrings)

I’m trying to get text elements from a local text file into an array. pets.txt contains cat dog Hopefully this code explains the problem. Thanks for looking! var pets; var petArray = []; function preload() { . . . pets = loadStrings("pets.txt"); petArray = pets.splitText(','); } function draw() { . . . fill(0); textSize(20); text(pets,60,height-10); //prints… cat,dog text(“X” + petArray[1],160,height-10); //prints… Xundefined }