TypeError: writeXlsxFile is not a function
Hello,
Continually getting writeXlsxFile is not a function. I have validated that this has been installed to the node_modules folder:
node Version: v12.16.1 Package.json:
{
"name": "excel-test2",
"version": "1.0.0",
"description": "",
"main": "index.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1"
},
"keywords": [],
"author": "",
"license": "ISC",
"dependencies": {
"write-excel-file": "^1.3.1"
}
}
code:
const { writeXlsxFile } = require('write-excel-file/node');
var main = async () => {
var rows = [
// Row #1
[
// Column #1
{
value: 'Name',
fontWeight: 'bold'
},
// Column #2
{
value: 'Date of Birth',
fontWeight: 'bold'
},
// Column #3
{
value: 'Cost',
fontWeight: 'bold'
},
// Column #4
{
value: 'Paid',
fontWeight: 'bold'
}
],
// Row #2
[
// Column #1
{
type: String,
value: 'John Smith'
},
// Column #2
{
type: Date,
value: new Date(),
format: 'mm/dd/yyyy'
},
// Column #3
{
type: Number,
value: 1800
},
// Column #4
{
type: Boolean,
value: true
}
],
// Row #3
[
// Column #1
{
type: String,
value: 'Alice Brown'
},
// Column #2
{
type: Date,
value: new Date(),
format: 'mm/dd/yyyy'
},
// Column #3
{
type: Number,
value: 2600
},
// Column #4
{
type: Boolean,
value: false
}
]
]
console.log(rows);
await writeXlsxFile(rows, { filePath: 'test.xlsx' });
};
main();