jquery - 风 sails :How can i read excel file data into json format

Question

上传 Excel 文件后，我尝试读取本地文件夹中的 Excel 文件。

var fs = require('fs');
    uploadFile.upload
             ({
                    // don't allow the total upload size to exceed ~10MB
                    maxBytes: 10000000, saveAs: function(uploadFile, cb) {cb(null,Date.now()+uploadFile.filename ); },dirname: '../../assets/uploads'
                },function whenDone(err, uploadedFiles) {
                if (err) 
                {
                    console.log("error");
                    return res.negotiate(err);
                }
                // If no files were uploaded, respond with an error.
                if (uploadedFiles.length === 0)
                {
                    return res.badRequest('No file was uploaded');
                }
               else
              {
                var fd = uploadedFiles[0].fd;
                                console.log(fd);
                                fs.readFile(fd, 'utf8', function (err, data) 
                                {
                                        console.log(data);


                                });
              }

如果是文本文件，则意味着我将成功读取，但对于 Excel 文件，我无法读取 Excel 数据。

我还需要将这个excel文件数据转换为json格式

Answer 1

尝试xlsx-rows

简单又容易:)

var fd = uploadedFiles[0].fd;
var rows = require('xlsx-rows')(fd);
rows = rows.slice(1);
rows.forEach(function(obj){
    // do something....
});