excel-compare

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

Downloads in past

Stats

StarsIssuesVersionUpdatedCreatedSize
excel-compare
0.1.39 years ago9 years agoMinified + gzip package size for excel-compare in KB

Readme

excel-compare
A node module to compare two column in two different excel files. Only support xlsx files.

Require

  • npm
  • node

Install

``` npm istall excel-compare ```

Usage

```javascript var excelcompare = require("excel-compare"); excelcompare({
file1: 'data/school.xlsx', // file1 is the main excel to compare with
file2: 'data/all.xlsx', // file2 is the file for compare
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.

Options

file1

Is the main excel you want to compare with (should be a xlsx file)

file2

The file for compare

columnfile1

Which column you want to choose in file1, enter the column order in array. you can also join two columns using join option.

columnfile2

same as column_file1 but for file2.

License

MIT