Jsonrawtoxlsx NPM

✨ What is jsonrawtoxlsx?

jsonrawtoxlsx is library to convert json raw (array) into xlsx file

⚡️ Installation

using npm

npm install jsonrawtoxlsx

using yarn

yarn add jsonrawtoxlsx

using pnpm

pnpm add jsonrawtoxlsx

🚀 Usage

Use to save as file:

const jsonrawtoxlsx = require('jsonrawtoxlsx');
const fs = require('fs');

const json = [
  {
    name: 'John',
    age: 27,
    job: 'Software Engineer',
  },
];

const buffer = jsonrawtoxlsx(json);

fs.writeFileSync('example.xlsx', buffer, 'binary');

Or use as express middleware. It adds a convenience xlsx method to the response object to immediately output an excel as download.

const express = require('express');
const jsonrawtoxlsx = require('jsonrawtoxlsx');
const app = express();
const PORT = 3000;

const data = [
  {
    name: 'John',
    age: 27,
    job: 'Software Engineer',
  },
  {
    name: 'John',
    age: 27,
    job: 'Software Engineer',
  },
];

app.use(jsonrawtoxlsx.middleware);
app.get('/', function (req, res) {
  res.xlsx('example.xlsx', data);
});

app.listen(PORT, function (err) {
  if (err) console.log(err);
  console.log('Server listening on PORT', PORT);
});

🤝 Contributing

Anyone can contribute with issues and PRs. If you're submitting a pull request, always create a new branch to work your changes, and try squashing commits down if possible. Always test any new code and make sure npm test passes and npm run test:cover for code coverage is adequate before opening a PR.