parseexcel

Usage

animal	weight	color
dog	20 kg	black
cat	5 kg	white
mouse	0.15 kg	gray

1. Parse excel file by path to array of javaScript objects

const { parseObj } = require('parseexcel')

const resArr = parseObj(filePath)

Result:

resArr = [
           { animal: 'dog', weight: '20 kg', color: 'black' },
           { animal: 'cat', weight: '5 kg', color: 'white' },
           { animal: 'mouse', weight: '0.15 kg', color: 'gray' }
         ]

2. Parse excel file by path to array of JSON

const { parseJson } = require('parseexcel')

const resArr = parseJson(filePath) 

Result:

resArr = [
           '{"animal":"dog","weight":"20 kg","color":"black"}',
           '{"animal":"cat","weight":"5 kg","color":"white"}',
           '{"animal":"mouse","weight":"0.15 kg","color":"gray"}'
         ]

3. Parse excel files (1 or more) from directory to array of javaScript objects

Table 1

phone	price	color
Xiaomi	100 $	blue
Samsung	150 $	white
Nokia	50 $	black

Table 2

TV	price	size	weight
LG	150 $	150	10
Horizont	50 $	70	12
Panasonic	250 $	120	8

Usage:

const { parseAllObj } = require('parseexcel')

const resArr = parseAllObj(directoryPath) 

Result:

resArr = [
           [
             { phone: 'Xiaomi', price: '100 $', color: 'blue' },
             { phone: 'Samsung', price: '150 $', color: 'white' },
             { phone: 'Nokia', price: '50 $', color: 'black' }
           ],
           [
             { TV: 'LG', price: '150 $', size: 150, weight: 10 },
             { TV: 'Horizont', price: '50 $', size: 70, weight: 12 },
             { TV: 'Panasonic', price: '250$', size: 120, weight: 8 }
           ]
         ]

4. Parse excel files (1 or more) from directory to array of JSON

const { parseAllJson } = require('parseexcel')

const resArr = parseAllJson(directoryPath) 

5. Parse Async excel files (1 or more) from directory to array of javaScript objects

const { parseAllObjAsync } = require('parseexcel')

const resArr = await parseAllObjAsync(directoryPath) 

6. Parse Async excel files (1 or more) from directory to array of JSON

const { parseAllJsonAsync } = require('parseexcel')

const resArr = await parseAllJsonAsync(directoryPath)