var fs = require('fs')
|
var path = require('path')
|
|
var officegen = require('../')
|
|
var outDir = path.join(__dirname, '../tmp/')
|
|
var xlsx = officegen('xlsx')
|
|
xlsx.on('finalize', function(written) {
|
console.log(
|
'Finish to create an Excel file.\nTotal bytes created: ' + written + '\n'
|
)
|
})
|
|
xlsx.on('error', function(err) {
|
console.log(err)
|
})
|
|
var sheet = xlsx.makeNewSheet()
|
sheet.name = 'Excel Test'
|
|
// The direct option - two-dimensional array:
|
sheet.data[0] = []
|
sheet.data[0][0] = 1
|
sheet.data[1] = []
|
sheet.data[1][3] = 'abc'
|
sheet.data[1][4] = 'More'
|
sheet.data[1][5] = 'Text'
|
sheet.data[1][6] = 'Here'
|
sheet.data[2] = []
|
sheet.data[2][5] = 'abc'
|
sheet.data[2][6] = 900
|
sheet.data[6] = []
|
sheet.data[6][2] = 1972
|
|
// Using setCell:
|
sheet.setCell('E7', 340)
|
sheet.setCell('I1', -3)
|
sheet.setCell('I2', 31.12)
|
sheet.setCell('G102', 'Hello World!')
|
|
var out = fs.createWriteStream(path.join(outDir, 'example.xlsx'))
|
|
out.on('error', function(err) {
|
console.log(err)
|
})
|
|
xlsx.generate(out)
|
