xlsx-util

This is a very basic package which allows us to use the native library xlsxio to read the data from an xlsx file.

We hope to provide more functionality in the future, but for now all you can do is extract the data from the first sheet of an xlsx file.

This is tested on Mac and Linux, but not tested on Windows.

npm install -s xlsx-util

Basic usage

const xlsx = require('xlsx-util')
const data = xlsx.readFile('myfilepath.xlsx')

Given an xlsx file like this

     A       B     C
   -----------------------------
1  | Hello |     | World       |
   -----------------------------
2  | 1     | 2   | 4           |
   -----------------------------
3  |       |     |             |
   -----------------------------
4  | 5     | 6   |             |
   -----------------------------
5  |       |     |             |
   -----------------------------
6  | pp    | or  | 0.085714286 |
   -----------------------------

We will get an array of objects like this:

[
  {
    "A": "Hello",
    "B": "World"
  },
  {
    "A": "1",
    "B": "2",
    "C": "4"
  },
  {
    "A": "5",
    "B": "6"
  },
  {
    "A": "pp",
    "B": "or",
    "C": "8.5714285714285715E-2"
  }
]

Notice that we are skipping empty rows. This is configurable in the underlying xlsxio library, but we haven't exposed the configuration.