simplified-json-to-excel

The simplified-json-to-excel is a package designed to simplify your work.

You may export your JSON data as an Excel file with this package. A json data is all you need to consider; nothing else.

Installation

Install simplified-json-to-excel with npm

  npm install --save simplified-json-to-excel

Install simplified-json-to-excel with yarn

  yarn add --save simplified-json-to-excel

Documentation

Features

• Convert json to excel with signle sheet
• Convert json to excel with multiple sheet

Usage => Data format

Single sheet excel file By default JSONToExcel accept an array of objects and generate an excel file with only one sheet.

An nested object will not be accepted and will return nothing the item with a value of an object

[
  {
    id: 1,
    name: "John",
    age: 30,
  },
  {
    id: 2,
    name: "Joe",
    age: 10,
  },
];

Multiple sheet excel file

With JSONToExcel you can create one excel file with different sheets with different content as you like. All you have to do is change the default format of your data. If the data structured correctly it will generate an excel file with multiple sheets without requiring more props or other configurations.

Here is an example of the acceptable data format for multiple sheets excel file.

[
  {
    sheetName: "Group A",
    data: [
      {
        id: 1,
        name: "John",
        age: 30,
      },
      {
        id: 2,
        name: "Joe",
        age: 10,
      },
    ],
  },
  {
    sheetName: "Group B",
    data: [
      {
        id: 1,
        name: "John",
        age: 20,
      },
    ],
  },
];

This example will generate one Excel file with two sheets: Group A & Group B;

Usage/Examples

import { JSONToExcel } from "simplified-json-to-excel";

function App() {
  const data = [
    {
      id: 1,
      name: "John",
      age: 30,
    },
    {
      id: 2,
      name: "Joe",
      age: 10,
    },
  ];

  return (
    <>
      <button onClick={() => JSONToExcel(data, "Name of the file")}>
        Generate File
      </button>
    </>
  );
}

Authors

• @pnayituriki

🔗 Links

Badges