Fancy TypeScript / JavaScript spreadsheet package for browsers, and node, and command line tools

Helps handle spreadsheet files `xlsx` in smart way by using high level api.

Packages

The xlsx-import

It allows you to import xlsx spreadsheet file with data into your system with defined TypeScript types.

const xlsx = await importerFactory.from('./my-awesome-books.xlsx');
const books: Array<Book> = xlsx.getAllItems<Book>(config.books);

Read more ➡️

The xlsx-renderer

Makes generating spreadsheet files as simple as possible - it is enough one line to generate pretty customizable spreadsheet file.

const renderer = new Renderer();
await renderer.renderFromFile('./invoice-template.xlsx', invoiceData)
    .then(wb => wb.xlsx.writeFile('./invoice.xlsx'));

Read more ➡️

Command Line Tools

The xlsx-import-cli (package: sxi)

Imports data from spreadsheet file using command line.

sxi books.cfg.js my-awesome-books.xlsx > books-list.json

Read more ➡️

The xlsx-renderer-cli (package: sxr)

Generate spreadsheets files following by the template with view model from command line.

sxr --model invoice-data.json invoice-template.xlsx > invoice.xlsx

Read more ➡️

Examples

Examples are available in a flat structure, and they are named by using : [package_name]+[technology] - for instance xlsx-import+nodejs+ts.

See samples/

Additionally, the xlsx-renderer has lots of examples used for the integration testing. Read more.

Support

If any help needed, just feel free to create an issue. We will be really thankful for added links into stackoverflow topics if exists.

We are ready to provide paid support, in order that please contact me: hi@siemienik.pl or support@siemienik.pl.

MIT licensed

All of these tools and packages are free to use for commercial and non-commercial usages, see the MIT License.