text based cue system from google sheets
Hey Y'all,
I'm playing in a computer music trio. We're working with google sheets for our text based scores - it's an easy way to have a synchronous version on each pc. Right now I'm working with coll and a subpatcher which does a linebreak every time a _ is detected. For this solution I have to manually copy every line into a txt file to read with coll - which is especially inconvenient because I oftentimes forget to type the integer comma at the beginning and the semicolon in each line.
What I want to know: Is there a way to export a csv or something else from google sheets with text in the cells, import that into max and trigger specific cells to output the text stored in them?
Thank You!
Best,
Benni
why don't you google google sheets export formats to check what it can export ?
Then post your findings here,
it should be possible to get that into coll or jit.cellblock
Thank you for your reply. I'll look into jit.cellblock.
I will have at least an index and three columns of text.
Google Sheets exports .xlsx, .html, .csv, .tsv and .ods.
celblock could come handy to display or recall cells in the sheet,
but it can not import any other than own file format.
That will need some sort of translator.
Either via coll, or then using text and dumping the spredsheet into
individual cells.