Fast-excel-to-json NPM

Fast Excel to JSON conversion using multithreading in Rust with WebAssembly

This library provides functions for converting Excel files into JSON objects, with an automatic conversion of Excel date formats into Unix timestamps by default. The library is optimized for performance by processing Excel rows in parallel, resulting in significant speed improvements when handling large datasets.

Installation

You can install this package using npm:

npm install fast-excel-to-json

Usage

To use the library, first require or import it in your JavaScript code:

const excelToJson = require('fast-excel-to-json');

Functions

`excel_to_json`

Converts a specific sheet from an xlsx file into a JSON object.

Parameters:

excel_data (Uint8Array): The binary data of the xlsx file.
sheet_index (number): The index of the sheet you want to convert (0-based).
is_iso8601 (boolean): A flag indicating whether dates should be formatted in ISO 8601 format.

Returns:

(object)[]: An array of JSON objects representing the data from the specified sheet.

Example:

const fs = require('fs');
const { excel_to_json } = require('fast-excel-to-json')

const excelData = fs.readFileSync('example.xlsx');
const sheetIndex = 0;
const isIso8601 = true;

const jsonData = excel_to_json(excelData, sheetIndex, isIso8601);
console.log(jsonData);

`all_excel_to_json`

Converts all sheets from an .xlsx file into JSON objects.

Parameters:

excel_data (Uint8Array): The binary data of the .xlsx file.
is_iso8601 (boolean): A flag indicating whether dates should be formatted in ISO 8601 format.

Returns:

any[]: An array of JSON objects, where each object corresponds to a sheet in the .xlsx file.

Example:

const fs = require('fs');
const { all_excel_to_json } = require('fast-excel-to-json')

const excelData = fs.readFileSync('example.xlsx');
const isIso8601 = true;

const allJsonData = all_excel_to_json(excelData, isIso8601);
console.log(allJsonData);

`csv_to_json`

Converts an .csv file into JSON objects.

Parameters:

csv_data (Uint8Array): The binary data of the .csv file.

Returns:

(object)[]: An array of JSON objects representing the data from .csv file.

Example:

const fs = require('fs');
const { csv_to_json } = require('fast-excel-to-json')

const data = fs.readFileSync('example.csv');

const json = csv_to_json(data);
console.log(json);