用NODEJS处理EXCEL文件导入导出

柔情只为你懂 2022-08-22 00:28 169阅读 0赞

参考文章

[http://librajt.github.io/2013/08/04/handle-excel-file-with-nodejs/][http_librajt.github.io_2013_08_04_handle-excel-file-with-nodejs]

[  
][http_librajt.github.io_2013_08_04_handle-excel-file-with-nodejs]

对比了 ExcelJS ,[ https://github.com/guyonroche/exceljs\#create-a-workbook  
][https_github.com_guyonroche_exceljs_create-a-workbook]

[node-xlsx][https_github.com_guyonroche_exceljs_create-a-workbook] ，[https://github.com/mgcrea/node-xlsx][https_github.com_mgcrea_node-xlsx]

等 nodejs 等现有组件，决定使用node-xlsx。

node-xlsx 基于现有前端强大组件 js-xlsx，  [https://github.com/SheetJS/js-xlsx][https_github.com_SheetJS_js-xlsx]

使用例子：

补充：

文件上传操作可以选择以下两种

fs                           [https://github.com/jprichardson/node-fs-extra][https_github.com_jprichardson_node-fs-extra]

formidable   https://github.com/felixge/node-formidable

[http_librajt.github.io_2013_08_04_handle-excel-file-with-nodejs]: http://librajt.github.io/2013/08/04/handle-excel-file-with-nodejs/
[https_github.com_guyonroche_exceljs_create-a-workbook]: http://mgcrea.github.com/node-xlsx
[https_github.com_mgcrea_node-xlsx]: https://github.com/mgcrea/node-xlsx
[https_github.com_SheetJS_js-xlsx]: https://github.com/SheetJS/js-xlsx
[https_github.com_jprichardson_node-fs-extra]: https://github.com/jprichardson/node-fs-extra