Create variables from coordinates array.
I have an excel file like so:
| Order | WO | Design | Qty | |
2551364 | 1 | 1248680 | 1 | |
| 2551365 | 2 | 1248681 | 3 | |
I am exporting the file to a tab-delimited txt file.
I want to be able to make variables from this data like:
var order = ??;
var wo = ??;
var design = ??;
var qty = ??;
Some of my excel files can get up into the thousands and i want to be able to change the variables above for each row then run a function for every row.
Found this post but cant seem to get it working with the ptArr array.
Re: Excel data to construct illustrator object
From that post the ptArr array gives the x,y coordinates of the "cell" i am looking for.
How can i reference this so var order = ptArr(0,0); , var wo = ptArr(0,1); etc?
