参考文章
http://librajt.github.io/2013/08/04/handle-excel-file-with-nodejs/
对比了 ExcelJS , https://github.com/guyonroche/exceljs#create-a-workbook
node-xlsx,https://github.com/mgcrea/node-xlsx
等 nodejs 等现有组件,决定使用node-xlsx。
node-xlsx 基于现有前端强大组件 js-xlsx, https://github.com/SheetJS/js-xlsx
简单使用例子:
var express = require('express');
var router = express.Router();
var xlsx = require('node-xlsx');
var fs = require('fs');
/* GET import excel test. */
router.get('/importExcel', function(req, res, next) {
var filename='./public/test.xlsx';
console.error(filename);
// read from a file
var obj = xlsx.parse(filename);
console.log(JSON.stringify(obj));
res.send('import successfully!');
});
/* GET export excel test. */
router.get('/exportExcel', function(req, res, next) {
// write
var data = [[1,2,3],[true, false, null, 'sheetj