miazzy / xtoolset Goto Github PK

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.

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 ➡️

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 ➡️

Imports data from spreadsheet file using command line.

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

Read more ➡️

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 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.

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: [email protected] or [email protected].

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