uber- noob: spreadsheet to jit.matrix
Just started with jitter recently and have been having fun playing with video in but now that I'm switching tactics...
I want my input to be grids of numerical data and my output to be a jit.matrix colorfield. I'm putting long lists of numbers into a message box but having trouble segmenting the data (would like my 20x20 jit.matrix to accept data cut and pasted from a 20x20 spreadsheet and have everything land in the same place even if some fields from my spreadsheet are blank).
Can someone point me in the right direction?
Thanks in advance for your help
Jit.cellblock
it's a start, but cellblock won't take cut-and-paste values directly from a spreadsheet like Excel, unless I missed something... you'd need to put them in manually or do some kind of spreadsheet-to-csv, load in a [text] or [coll], then parse and load into the cells... no quick or easy way to do it built-in.
feature request: cellblock loads .csv? :) I know it's been asked before and is probably a pain... but hey.
I remember someone on here had a clever .js that was able to populate cellblock like this, or maybe it was read cellblock into a .csv, can't recall...it was a while ago.
It would be good if cellblock or coll could load a csv file directly, but until then, from this thread:
https://cycling74.com/forums/importing-from-excel-csv-questions
driftpattern posted this (I've slightly modified it):
Oooh! Nicely done, Terry! This is an elegant take of the Driftpattern version. I guess I can't go out of coll to a matrix or jit.pwindow. I know I can use write to create another file and then jit.textfile to bring it back in, but is there a one-step way to go from coll to a 3 or 4 plane matrix?