Get a javascript array from an Excel

In the same way you can write a javascript array to an Excel it’s equally easy to retrieve a javascript array from an existing Excel. Let’s take this excel sheet as an example (from test.xlsx):

To convert it to a javascript array just create the following OpenAF script (test.js):

plugin("XLS");
var xls = new XLS("test.xlsx");
var sheet = xls.getSheet("Sheet1");
// The second boolean parameter determines if formulas should be evaluated
var myArray = xls.getTable(sheet, true, "B", 3).table;

sprint(myArray);

And execute it:

openaf -f test.js

The result will be:

[
  {
    "ID": 1,
    "Description": "Test 1",
    "Value": 123
  },
  {
    "ID": 2,
    "Description": "Test 2",
    "Value": 321
  },
  {
    "ID": 3,
    "Description": "Test 3",
    "Value": 456
  },
  {
    "ID": 4,
    "Description": "Test 4",
    "Value": 654
  }
]