Skip to content

An attempt to use xlsxio and possible bring it into Node.js

License

Notifications You must be signed in to change notification settings

bitflipsoftware/xlsx-util

Repository files navigation

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.

About

An attempt to use xlsxio and possible bring it into Node.js

Resources

License

Stars

Watchers

Forks

Packages

No packages published