xlsx-to-js

Xlsx-to-js

A TypeScript-based library for parsing Excel (XLSX) with browser support.

Getting Started

Installation

With npm:

npm install --save xlsx-to-js

Import library:

import { XlsxParser } from "xlsx-to-js";

Usage

Parsing Workbooks

Extract data from spreadsheet bytes

const xlsxParser = new XlsxParser();
const workbook = await xlsxParser.readFile(file, { dense: true, styles: true, drawings: true, skipHiddenRows: true });

The readFile method extract data from spreadsheet bytes stored in a ArrayBuffer.

The second argument to options accepts the properties:

Option	Default	Description
dense	false	When the option dense: false is passed, parsers will skip empty cells.
styles	false	When the opction styles: false is passed, parsers will skip cell styles.
drawings	false	When the option drawings: false is passed, parsers will skip parsing drawings and graphical objects.
skipHiddenRows	false	When the option skipHiddenRows: true is passed, hidden rows will be ignored during parsing.

References

• ISO/IEC 29500:2012 "Office Open XML File Formats — Fundamentals And Markup Language Reference"