excel-compair

A node module to compair two column in two different excel files.

npm install excel-compair
4 downloads in the last month

Excel compairer

A node module to compair two column in two different excel files. Only supported xlsx files.

Require

  • npm
  • node

Install

npm istall excel-compair

Usage

var excel_compair = require("excel-compair");

excel_compair({
    file1: 'data/school.xlsx', // file1 is the main excel to compair with
    file2: 'data/all.xlsx', // file2 is the file for compair
    column_file1: {
        column: [1],
        join: ''
    },
    column_file2: {
        column: [1, 2],
        join: '-'
    }
})

and the system will return a array, that is on file1 but not in file2.

License

MIT

npm loves you