1
import xlsx from 'node-xlsx';
2
import * as fs from 'fs';
3
import path from "path"
4

5
// const data = [
6
//   [1, 2, 3],
7
//   [true, false, null, 'sheetjs'],
8
//   ['foo', 'bar', new Date('2014-02-19T14:30Z'), '0.3'],
9
//   ['baz', null, 'qux'],
10
// ];
11
// var buffer = xlsx.build([{ name: 'mySheetName', data: data }]); // Returns a buffer
12

13
// fs.writeFileSync('./test.xlsx', buffer, { 'flag': 'w' });
14

15
const options = {
16
  type: "buffer",
17
  cellDates: true,
18
  cellHTML: false,
19
  dateNF: "yyyy-mm-dd hh:mm:ss",
20
  cellNF: true
21
};
22

23
const workSheetsFromFile = xlsx.parse(`${path.resolve()}/test.xlsx`, options);
24
console.log(workSheetsFromFile[0].data);