json-and-xlsx v2.1.2

json-and-xlsx

A package for converting JSON to XLSX and XLSX to JSON

Global Functions

xlsxToJson

This function is used to handle xlsx to json conversions

readAndGet(xlsxData)

Reads workbook returns a json output

Usage

Xlsx Data in Sheet1

const {xlsxToJson} = require('json-and-xlsx');

const workbook = require('./workbook'); // Get Workbook

const output = xlsxToJson.readAndGet(workbook);
/*
    returns [
    {
        title: 'Title 1',
        description: 'Desc 1'
    },
    {
        title: 'Title 2',
        description: 'Desc 2'
    }
];
*/

readFromBufferAndGet(buffer)

Reads from a buffer and returns a json output

Usage

const {xlsxToJson} = require('json-and-xlsx');
const buffer = require('./buffer-data.js');

const output = xlsxToJson.readFromBufferAndGet(buffer);
/*
    returns [
    {
        title: 'Title 1',
        description: 'Desc 1'
    },
    {
        title: 'Title 2',
        description: 'Desc 2'
    }
];
*/

readFromFileAndGet(xlsxData)

Reads workbook returns a json output

Usage

Xlsx Data in Sheet1 stored in workbook.xlsx

const {xlsxToJson} = require('json-and-xlsx');

const output = xlsxToJson.readFromFileAndGet('workbook.xlsx');
/*
    returns [
    {
        title: 'Title 1',
        description: 'Desc 1'
    },
    {
        title: 'Title 2',
        description: 'Desc 2'
    }
];
*/

jsonToXlsx

This function is used to handle json to xlsx conversions

//  json-data.json
[
    {
        "title": "Title 1",
        "description": "Desc 1"
    },
    {
        "title": "Title 2",
        "description": "Desc 2"
    }
]

readAndGet(jsonData)

Reads json returns a workbook

const {jsonToXlsx} = require('json-and-xlsx');

const jsonData = [
    {
        title: "Title 1",
        description: "Desc 1"
    },
    {
        title: "Title 2",
        description: "Desc 2"
    }
]; // Could be a JSON String

const output = jsonToXlsx.readAndGet(jsonData);
/*
    returns Workbook
*/

readAndGetBuffer(jsonData)

Reads json returns a buffer of the workbook

const {jsonToXlsx} = require('json-and-xlsx');

const jsonData = [
    {
        title: "Title 1",
        description: "Desc 1"
    },
    {
        title: "Title 2",
        description: "Desc 2"
    }
]; // Could be a JSON String

const output = jsonToXlsx.readAndGetBuffer(jsonData);
/*
    returns Buffer
*/

readFromFileAndGet(sourceFilePath)

Reads json returns a workbook

const {jsonToXlsx} = require('json-and-xlsx');

const output = jsonToXlsx.readFromFileAndGet('json-data.json');
/*
    returns Workbook
*/

readFromFileAndGetBuffer(sourceFilePath)

Reads json from sourceFile and returns a Buffer

const {jsonToXlsx} = require('json-and-xlsx');

const output = jsonToXlsx.readFromFileAndGetBuffer('json-data.json');
/*
    returns Buffer
*/

readFromFileToFile(sourceFilePath, destFilePath)

Reads json from file and writes the workbook to a file

const {jsonToXlsx} = require('json-and-xlsx');

jsonToXlsx.readFromFileToFile('json-data.json', 'workbook.xlsx');
/*
    writes json to workbook.xlsx
*/