Excel by default tab delimits the data and uses newlines to separate rows. You should have a final newline automatically from excel when you paste. Do not delete that newline as it can cause data loss.
Basically you select your table in excel. Copy. Paste it into the dialog. If your data has headers (or not) make sure the box is checked appropriately. You can select which token name you want the table to be placed as well as the variable name.
When you import data with headers it'll make a json array where each row's data has keys. Without headers you get an array of arrays.
- Excel Table
- Image1.PNG (5.34 KiB) Viewed 1528 times
- Import Dialog
- Image2.PNG (54.53 KiB) Viewed 1528 times
XLI.table(string tableName, <int vlookup, string tableLocation>);
if you don't give it a vlookup it'll find the biggest number X in your keys and roll 1dX on the table, sort of like the regular table function. If you don't give it a location it will use currentToken().
Basically you can import properly formatted tables from excel and roll against them easily. The function returns that row's json with your roll substituted for the key.
Example: Below is a table for rolling random colors.
Interpreted as <=10 Red, 11-25 Blue, <=100 Orange
10 Red
25 Blue
100 Orange
XLI.table("XLI_table",1d100, "Lib: XLImport")
Output: [30,"Orange"]
XLI.table("XLI_table",-5, "Lib: XLImport")
Output: [-5,"Red"]
Let me know if you have any issues.
Enjoy!
