blocks|key|779387|text|有几个不同的库在解析Excel文件(.xlsx)。我会列出两个我觉得有趣和值得研究的项目。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|779388|节点-xlsx|779389|Excel解析器和生成器。它是流行项目https://github.com/SheetJS/js-xlsx的包装器，它是Office规范的纯javascript实现。|offset|length|779390|https://github.com/mgcrea/node-xlsx|779391|解析文件示例|779392|var+xlsx+=+require('node-xlsx');

var+obj+=+xlsx.parse(__dirname+%2B+'/myFile.xlsx');+//+parses+a+file

var+obj+=+xlsx.parse(fs.readFileSync(__dirname+%2B+'/myFile.xlsx'));+//+parses+a+buffer|code-block|syntax|javascript|779393|ExcelJS|779394|将电子表格数据和样式读取、操作和写入到XLSX和JSON。这是一个积极的项目。在撰写本报告时，最近一次提交是在9小时前。我自己还没有测试过这一点，但是api看起来很广泛，有很多可能性。|779395|https://github.com/guyonroche/exceljs|779396|代码示例：|779397|//+read+from+a+file
var+workbook+=+new+Excel.Workbook();
workbook.xlsx.readFile(filename)
++++.then(function()+{
++++++++//+use+workbook
++++});

//+pipe+from+stream
var+workbook+=+new+Excel.Workbook();
stream.pipe(workbook.xlsx.createInputStream());|779398|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/SheetJS/js-xlsx|1|2^0|0|0|J|Y|0|0|0|Z|1|0|0|0|0|0|0|11|2|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1C|8|@]|9|@$F|1D|G|1E|1|1F]]|A|$]]|$1|H|3|I|5|6|7|1G|8|@]|9|@$F|1H|G|1I|1|1J]]|A|$]]|$1|J|3|K|5|6|7|1K|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1L|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1M|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1N|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1O|8|@]|9|@$F|1P|G|1Q|1|1R]]|A|$]]|$1|W|3|X|5|6|7|1S|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|N|7|1T|8|@]|9|@]|A|$O|P]]|$1|10|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]|18|$5|13|14|15|A|$16|I]]|19|$5|13|14|15|A|$16|V]]]]

There are a few different libraries doing parsing of Excel files (.xlsx). I will list two projects I find interesting and worth looking into.

<h3>Node-xlsx</h3>

Excel parser and builder. It's kind of a wrapper for a popular project <a href="https://github.com/SheetJS/js-xlsx" rel="noreferrer">JS-XLSX</a>, which is a pure javascript implementation from the Office Open XML spec. 

<a href="https://github.com/mgcrea/node-xlsx" rel="noreferrer">node-xlsx project page</a> 

Example for parsing file

<pre><code>var xlsx = require('node-xlsx');

var obj = xlsx.parse(__dirname + '/myFile.xlsx'); // parses a file

var obj = xlsx.parse(fs.readFileSync(__dirname + '/myFile.xlsx')); // parses a buffer
</code></pre>

<h3>ExcelJS</h3>

Read, manipulate and write spreadsheet data and styles to XLSX and JSON. It's an active project. At the time of writing the latest commit was 9 hours ago. I haven't tested this myself, but the api looks extensive with a lot of possibilites.

<a href="https://github.com/guyonroche/exceljs" rel="noreferrer">exceljs project page</a> 

Code example:

<pre><code>// read from a file
var workbook = new Excel.Workbook();
workbook.xlsx.readFile(filename)
 .then(function() {
 // use workbook
 });

// pipe from stream
var workbook = new Excel.Workbook();
stream.pipe(workbook.xlsx.createInputStream());
</code></pre>

blocks|key|2076128|text|安装“spread_sheet”节点模块，它将从本地电子表格中添加和获取行|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2076129|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Install 'spread_sheet' node module,it will both add and fetch row from local spreadsheet

blocks|key|779479|text|您还可以使用这个称为js-xlsx的节点模块。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|779480|1)安装模块|779481|npm+install+xlsx|style|CODE|779482|2)导入模块%2B代码段|779483|var+XLSX+=+require('xlsx')
var+workbook+=+XLSX.readFile('Master.xlsx');
var+sheet_name_list+=+workbook.SheetNames;
var+xlData+=+XLSX.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]]);
console.log(xlData);|code-block|syntax|javascript|779484|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/SheetJS/js-xlsx^0|A|7|0|0|0|0|G|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|13|8|@$A|14|B|15|H|I]]|9|@]|C|$]]|$1|J|3|K|5|6|7|16|8|@]|9|@]|C|$]]|$1|L|3|M|5|N|7|17|8|@]|9|@]|C|$O|P]]|$1|Q|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

You can also use this node module called <a href="https://github.com/SheetJS/js-xlsx" rel="noreferrer">js-xlsx</a>
 
 1) Install module
 <code>npm install xlsx</code> 
 2) Import module + code snippet 

<pre><code>var XLSX = require('xlsx')
var workbook = XLSX.readFile('Master.xlsx');
var sheet_name_list = workbook.SheetNames;
var xlData = XLSX.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]]);
console.log(xlData);
</code></pre>

blocks|key|779514|text|安装exceljs并使用以下代码，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|779515|var+Excel+=+require('exceljs');

var+wb+=+new+Excel.Workbook();
var+path+=+require('path');
var+filePath+=+path.resolve(__dirname,'sample.xlsx');

wb.xlsx.readFile(filePath).then(function(){

++++var+sh+=+wb.getWorksheet("Sheet1");

++++sh.getRow(1).getCell(2).value+=+32;
++++wb.xlsx.writeFile("sample2.xlsx");
++++console.log("Row-3+%7C+Cell-2+-+"%2Bsh.getRow(3).getCell(2).value);

++++console.log(sh.rowCount);
++++//Get+all+the+rows+data+[1st+and+2nd+column]
++++for+(i+=+1;+i+<=+sh.rowCount;+i%2B%2B)+{
++++++++console.log(sh.getRow(i).getCell(1).value);
++++++++console.log(sh.getRow(i).getCell(2).value);
++++}
});|code-block|syntax|javascript|779516|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

install exceljs and use the following code,

<pre><code>var Excel = require('exceljs');

var wb = new Excel.Workbook();
var path = require('path');
var filePath = path.resolve(__dirname,'sample.xlsx');

wb.xlsx.readFile(filePath).then(function(){

 var sh = wb.getWorksheet("Sheet1");

 sh.getRow(1).getCell(2).value = 32;
 wb.xlsx.writeFile("sample2.xlsx");
 console.log("Row-3 | Cell-2 - "+sh.getRow(3).getCell(2).value);

 console.log(sh.rowCount);
 //Get all the rows data [1st and 2nd column]
 for (i = 1; i &lt;= sh.rowCount; i++) {
 console.log(sh.getRow(i).getCell(1).value);
 console.log(sh.getRow(i).getCell(2).value);
 }
});
</code></pre>

blocks|key|779522|text|有用链接|type|unstyled|depth|inlineStyleRanges|entityRanges|data|779523|https://ciphertrick.com/read-excel-files-convert-json-node-js/|offset|length|779524|+var+express+=+require('express');+
++++var+app+=+express();+
++++var+bodyParser+=+require('body-parser');
++++var+multer+=+require('multer');
++++var+xlstojson+=+require("xls-to-json-lc");
++++var+xlsxtojson+=+require("xlsx-to-json-lc");
++++app.use(bodyParser.json());
++++var+storage+=+multer.diskStorage({+//multers+disk+storage+settings
++++++++destination:+function+(req,+file,+cb)+{
++++++++++++cb(null,+'./uploads/')
++++++++},
++++++++filename:+function+(req,+file,+cb)+{
++++++++++++var+datetimestamp+=+Date.now();
++++++++++++cb(null,+file.fieldname+%2B+'-'+%2B+datetimestamp+%2B+'.'+%2B+file.originalname.split('.')[file.originalname.split('.').length+-1])
++++++++}
++++});
++++var+upload+=+multer({+//multer+settings
++++++++++++++++++++storage:+storage,
++++++++++++++++++++fileFilter+:+function(req,+file,+callback)+{+//file+filter
++++++++++++++++++++++++if+(['xls',+'xlsx'].indexOf(file.originalname.split('.')[file.originalname.split('.').length-1])+===+-1)+{
++++++++++++++++++++++++++++return+callback(new+Error('Wrong+extension+type'));
++++++++++++++++++++++++}
++++++++++++++++++++++++callback(null,+true);
++++++++++++++++++++}
++++++++++++++++}).single('file');
++++/**+API+path+that+will+upload+the+files+*/
++++app.post('/upload',+function(req,+res)+{
++++++++var+exceltojson;
++++++++upload(req,res,function(err){
++++++++++++if(err){
+++++++++++++++++res.json({error_code:1,err_desc:err});
+++++++++++++++++return;
++++++++++++}
++++++++++++/**+Multer+gives+us+file+info+in+req.file+object+*/
++++++++++++if(!req.file){
++++++++++++++++res.json({error_code:1,err_desc:"No+file+passed"});
++++++++++++++++return;
++++++++++++}
++++++++++++/**+Check+the+extension+of+the+incoming+file+and+
+++++++++++++*++use+the+appropriate+module
+++++++++++++*/
++++++++++++if(req.file.originalname.split('.')[req.file.originalname.split('.').length-1]+===+'xlsx'){
++++++++++++++++exceltojson+=+xlsxtojson;
++++++++++++}+else+{
++++++++++++++++exceltojson+=+xlstojson;
++++++++++++}
++++++++++++try+{
++++++++++++++++exceltojson({
++++++++++++++++++++input:+req.file.path,
++++++++++++++++++++output:+null,+//since+we+don't+need+output.json
++++++++++++++++++++lowerCaseHeaders:true
++++++++++++++++},+function(err,result){
++++++++++++++++++++if(err)+{
++++++++++++++++++++++++return+res.json({error_code:1,err_desc:err,+data:+null});
++++++++++++++++++++}+
++++++++++++++++++++res.json({error_code:0,err_desc:null,+data:+result});
++++++++++++++++});
++++++++++++}+catch+(e){
++++++++++++++++res.json({error_code:1,err_desc:"Corupted+excel+file"});
++++++++++++}
++++++++})
++++});+
++++app.get('/',function(req,res){
++++++++res.sendFile(__dirname+%2B+"/index.html");
++++});
++++app.listen('3000',+function(){
++++++++console.log('running+on+3000...');
++++});|code-block|syntax|javascript|779525|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1Q|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|H|7|W|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|C]]]]

Useful link

<a href="https://ciphertrick.com/read-excel-files-convert-json-node-js/" rel="nofollow noreferrer">https://ciphertrick.com/read-excel-files-convert-json-node-js/</a>

<pre><code> var express = require('express'); 
 var app = express(); 
 var bodyParser = require('body-parser');
 var multer = require('multer');
 var xlstojson = require("xls-to-json-lc");
 var xlsxtojson = require("xlsx-to-json-lc");
 app.use(bodyParser.json());
 var storage = multer.diskStorage({ //multers disk storage settings
 destination: function (req, file, cb) {
 cb(null, './uploads/')
 },
 filename: function (req, file, cb) {
 var datetimestamp = Date.now();
 cb(null, file.fieldname + '-' + datetimestamp + '.' + file.originalname.split('.')[file.originalname.split('.').length -1])
 }
 });
 var upload = multer({ //multer settings
 storage: storage,
 fileFilter : function(req, file, callback) { //file filter
 if (['xls', 'xlsx'].indexOf(file.originalname.split('.')[file.originalname.split('.').length-1]) === -1) {
 return callback(new Error('Wrong extension type'));
 }
 callback(null, true);
 }
 }).single('file');
 /** API path that will upload the files */
 app.post('/upload', function(req, res) {
 var exceltojson;
 upload(req,res,function(err){
 if(err){
 res.json({error_code:1,err_desc:err});
 return;
 }
 /** Multer gives us file info in req.file object */
 if(!req.file){
 res.json({error_code:1,err_desc:"No file passed"});
 return;
 }
 /** Check the extension of the incoming file and 
 * use the appropriate module
 */
 if(req.file.originalname.split('.')[req.file.originalname.split('.').length-1] === 'xlsx'){
 exceltojson = xlsxtojson;
 } else {
 exceltojson = xlstojson;
 }
 try {
 exceltojson({
 input: req.file.path,
 output: null, //since we don't need output.json
 lowerCaseHeaders:true
 }, function(err,result){
 if(err) {
 return res.json({error_code:1,err_desc:err, data: null});
 } 
 res.json({error_code:0,err_desc:null, data: result});
 });
 } catch (e){
 res.json({error_code:1,err_desc:"Corupted excel file"});
 }
 })
 }); 
 app.get('/',function(req,res){
 res.sendFile(__dirname + "/index.html");
 });
 app.listen('3000', function(){
 console.log('running on 3000...');
 });
</code></pre>

blocks|key|779610|text|您可以使用读取-excel-文件+npm。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|779611|在这种情况下，您可以指定JSON+将XLSX转换为JSON格式。|style|BOLD|779612|const+readXlsxFile+=+require('read-excel-file/node');

const+schema+=+{
++++'Segment':+{
++++++++prop:+'Segment',
++++++++type:+String
++++},
++++'Country':+{
++++++++prop:+'Country',
++++++++type:+String
++++},
++++'Product':+{
++++++++prop:+'Product',
++++++++type:+String
++++}
}

readXlsxFile('sample.xlsx',+{+schema+}).then(({+rows,+errors+})+=>+{
++++console.log(rows);
});|code-block|syntax|javascript|779613|entityMap|0|LINK|mutability|MUTABLE|url|https://www.npmjs.com/package/read-excel-file^0|5|B|0|0|C|5|I|4|P|4|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@$A|Z|B|10|F|G]|$A|11|B|12|F|G]|$A|13|B|14|F|G]]|9|@]|C|$]]|$1|H|3|I|5|J|7|15|8|@]|9|@]|C|$K|L]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

You can use <a href="https://www.npmjs.com/package/read-excel-file" rel="noreferrer">read-excel-file</a> npm.

In that,
you can specify JSON Schema to convert XLSX into JSON Format.

<pre><code>const readXlsxFile = require('read-excel-file/node');

const schema = {
 'Segment': {
 prop: 'Segment',
 type: String
 },
 'Country': {
 prop: 'Country',
 type: String
 },
 'Product': {
 prop: 'Product',
 type: String
 }
}

readXlsxFile('sample.xlsx', { schema }).then(({ rows, errors }) =&gt; {
 console.log(rows);
});
</code></pre>

Okay so i am using the <code>FileUploader</code> module to upload my file from angular to my <code>REST API</code>:

<pre><code>var uploader = $scope.uploader = new FileUploader({
 url: api.getUrl('uploadCompetence',null)
});
</code></pre>

This is sent to the following <code>POST</code> function:

<pre><code> router.route('/api/uploadCompetence')
 .post(function (req, res) {

 // This is where i want to read the file

 var competence = Competence.build(req.body.location);
 competence.add(function (success) {
 res.json({message: 'quote created!'});
 },
 function (err) {
 res.status(err).send(err);
 });
 })
</code></pre>

Now my goal is to read the <code>excel</code> file and then add each row to my database.

However im not quite sure how i can read the file from <code>Node.js</code> i have debugged my server and couldnt find the file anywhere but the the api is being called from my <code>Angular</code> application

Can anyone push me in the right direction? :)

Reading Excel file using node.js

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

好的，我使用FileUploader模块将文件从角上传到REST APIvar uploader = $scope.uploader = new FileUploader({    url: api.getUrl('uploadCompetence',null)});这将发送到以下POST函数：        rout...

问用node.js读取Excel文件
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用node.js读取Excel文件EN