entityMap|blocks|key|6fevs|text|XLS是Microsoft使用的二进制专有格式。如果不使用特定的库或Office+Interop，使用服务器端语言解析XLS是非常困难的。用javascript来做这件事是不可能完成的任务。多亏了HTML5+File+API，您可以读取它的二进制内容，但是为了解析和解释它，您需要深入研究|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3orue|XLS格式的规范|82ihv|..。从Office+2007开始，Microsoft采用了|1nhio|打开XML|3ltvm|文件格式(|5p2sv|对于Excel)，这是一个标准。^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|N|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|O|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|P|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|Q|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|R|9|@]|A|@]|B|$]]]]

<p>XLS is a binary proprietary format used by Microsoft. Parsing XLS with server side languages is very difficult without using some specific library or Office Interop. Doing this with javascript is mission impossible. Thanks to the HTML5 File API you can read its binary contents but in order to parse and interpret it you will need to dive into the <a href="http://www.microsoft.com/interop/docs/OfficeBinaryFormats.mspx" rel="nofollow">specifications of the XLS format</a>. Starting from Office 2007, Microsoft embraced the <a href="http://www.microsoft.com/interop/docs/OfficeBinaryFormats.mspx" rel="nofollow">Open XML</a> file formats (<code>xslx</code> for Excel) which is a standard.</p>


entityMap|blocks|key|2gpbl|text|var+excel=new+ActiveXObject("Excel.Application")；var+book=excel.Workbooks.Open(您的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|am68b|_|6ipnh|完整|397cm|6bi2d|文件|la0d|7ortb|名称|bricj|bu2ui|here.xls)；var+sheet=book.Sheets.Item(1)；var+value=sheet.Range("A1")；|dtevd|当你拿到床单的时候。您可以像在Excel中一样使用VBA函数。^0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|S|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|T|9|@]|A|@]|B|$]]|$2|G|4|D|6|7|8|U|9|@]|A|@]|B|$]]|$2|H|4|I|6|7|8|V|9|@]|A|@]|B|$]]|$2|J|4|D|6|7|8|W|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|X|9|@]|A|@]|B|$]]|$2|M|4|D|6|7|8|Y|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|Z|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|10|9|@]|A|@]|B|$]]]]

<p>var excel=new ActiveXObject("Excel.Application");
var book=excel.Workbooks.Open(your_full_file_name_here.xls);
var sheet=book.Sheets.Item(1);
var value=sheet.Range("A1");</p>

<p>when you have the sheet. You could use VBA functions as you do in Excel.</p>


entityMap|blocks|key|82okb|text|老问题，但我应该注意到，从javascript解析XLS文件的一般任务是乏味和困难的，但并不是不可能的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4dd04|我有用纯JS实现的基本解析器：|7p11j|http://oss.sheetjs.com/js-xls/|15g1q|(XLS文件，您想要的文件)|ef66|http://oss.sheetjs.com/js-xlsx/|8ohfg|(XLSX/XLSM/XLSB文件)|1sk0q|这两个页面都是HTML5+File+API驱动的XLS/XLSX解析器(您可以拖放您的文件，它将以逗号分隔的列表打印出单元格中的数据)。您还可以生成JSON对象(假设第一行是标题行)。|fmqog|测试套件|e1j99|http://oss.sheetjs.com/|fjl92|显示了使用XHR获取和解析文件的版本。^0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|U|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|V|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|W|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|X|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|Y|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|Z|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|10|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|11|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|12|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|13|9|@]|A|@]|B|$]]]]

<p>Old question, but I should note that the general task of parsing XLS files from javascript is tedious and difficult but not impossible.</p>

<p>I have basic parsers implemented in pure JS:</p>

<ul>
<li><a href="http://oss.sheetjs.com/js-xls/">http://oss.sheetjs.com/js-xls/</a> (XLS files, what you wanted)</li>
<li><a href="http://oss.sheetjs.com/js-xlsx/">http://oss.sheetjs.com/js-xlsx/</a> (XLSX/XLSM/XLSB files)</li>
</ul>

<p>Both pages are HTML5 File API-driven XLS/XLSX parsers (you can drag-drop your file and it will print out the data in the cells in a comma-separated list).  You can also generate JSON objects (assuming the first row is a header row).</p>

<p>The test suite <a href="http://oss.sheetjs.com/">http://oss.sheetjs.com/</a> shows a version that uses XHR to get and parse files.</p>


entityMap|blocks|key|2j6iv|text|下面的函数将Excel工作表(XLSX格式)数据转换为JSON。您可以将promise添加到函数中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|51g74|var+ExcelToJSON+=+function()+{

++this.parseExcel+=+function(file)+{
++++var+reader+=+new+FileReader();

++++reader.onload+=+function(e)+{
++++++var+data+=+e.target.result;
++++++var+workbook+=+XLSX.read(data,+{
++++++++type:+'binary'
++++++});

++++++workbook.SheetNames.forEach(function(sheetName)+{
++++++++//+Here+is+your+object
++++++++var+XL_row_object+=+XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
++++++++var+json_object+=+JSON.stringify(XL_row_object);
++++++++console.log(json_object);

++++++})

++++};

++++reader.onerror+=+function(ex)+{
++++++console.log(ex);
++++};

++++reader.readAsBinaryString(file);
++};
};|code-block|syntax|javascript|do5kf|下面的post包含XLS格式的代码|ef42m|Excel转JSON+javascript代码？^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|O|9|@]|A|@]|B|$]]]]

<p>Below Function converts the Excel sheet (XLSX format) data to JSON. you can add promise to the function. </p>

<pre><code>&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js"&gt;&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.js"&gt;&lt;/script&gt;
&lt;script&gt;
var ExcelToJSON = function() {

  this.parseExcel = function(file) {
    var reader = new FileReader();

    reader.onload = function(e) {
      var data = e.target.result;
      var workbook = XLSX.read(data, {
        type: 'binary'
      });

      workbook.SheetNames.forEach(function(sheetName) {
        // Here is your object
        var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
        var json_object = JSON.stringify(XL_row_object);
        console.log(json_object);

      })

    };

    reader.onerror = function(ex) {
      console.log(ex);
    };

    reader.readAsBinaryString(file);
  };
};
&lt;/script&gt;
</code></pre>

<p>Below post has the code for XLS format <a href="https://stackoverflow.com/questions/28782074/excel-to-json-javascript-code">Excel to JSON javascript code?</a> </p>


entityMap|blocks|key|1j5vl|text|这段代码可以帮助你|type|unstyled|depth|inlineStyleRanges|entityRanges|data|cbjul|大多数情况下，jszip.js无法工作，因此请在您的js代码中包含xlsx.full.min.js。|3n2i6|Html代码|dcu4d|Javascript|b2tlo|$scope.ExcelExport=+function+(event)+{


++++var+input+=+event.target;
++++var+reader+=+new+FileReader();
++++reader.onload+=+function(){
++++++++var+fileData+=+reader.result;
++++++++var+wb+=+XLSX.read(fileData,+{type+:+'binary'});

++++++++wb.SheetNames.forEach(function(sheetName){
++++++++var+rowObj+=XLSX.utils.sheet_to_row_object_array(wb.Sheets[sheetName]);
++++++++var+jsonObj+=+JSON.stringify(rowObj);
++++++++console.log(jsonObj)
++++++++})
++++};
++++reader.readAsBinaryString(input.files[0]);
++++};|code-block|syntax|javascript^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|O|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|P|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|Q|9|@]|A|@]|B|$]]|$2|I|4|J|6|K|8|R|9|@]|A|@]|B|$L|M]]]]

<p>This code can help you<br>Most of the time jszip.js is not working so include xlsx.full.min.js in your js code.</p>

<h1>Html Code</h1>

<pre><code> &lt;input type="file" id="file" ng-model="csvFile"  
    onchange="angular.element(this).scope().ExcelExport(event)"/&gt;
</code></pre>

<h1>Javascript</h1>

<pre><code>&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.js"&gt;
&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js"&gt;
&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.10.8/xlsx.full.min.js"&gt;
&lt;/script&gt;

$scope.ExcelExport= function (event) {


    var input = event.target;
    var reader = new FileReader();
    reader.onload = function(){
        var fileData = reader.result;
        var wb = XLSX.read(fileData, {type : 'binary'});

        wb.SheetNames.forEach(function(sheetName){
        var rowObj =XLSX.utils.sheet_to_row_object_array(wb.Sheets[sheetName]);
        var jsonObj = JSON.stringify(rowObj);
        console.log(jsonObj)
        })
    };
    reader.readAsBinaryString(input.files[0]);
    };
</code></pre>


entityMap|blocks|key|dr1bq|text|如果你想知道如何从服务器读取文件，这段代码可能会有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|74cet|限制：|57l20|文件应该在服务器中(本地/远程)。|9bcl5|你将不得不设置标题或有CORS谷歌插件。|12euk|/*+set+up+XMLHttpRequest+*/


++++//+replace+it+with+your+file+path+in+local+server
++++var+url+=+"http://localhost/test.xlsx";

++++var+oReq+=+new+XMLHttpRequest();
++++oReq.open("GET",+url,+true);
++++oReq.responseType+=+"arraybuffer";

++++oReq.onload+=+function(e)+{
++++++++var+arraybuffer+=+oReq.response;

++++++++/*+convert+data+to+binary+string+*/
++++++++var+data+=+new+Uint8Array(arraybuffer);

++++++++var+arr+=+new+Array();
++++++++for+(var+i+=+0;+i+!=+data.length;+%2B%2Bi)+{
++++++++++++arr[i]+=+String.fromCharCode(data[i]);
++++++++}

++++++++var+bstr+=+arr.join("");

++++++++var+cfb+=+XLSX.read(bstr,+{+type:+'binary'+});

++++++++cfb.SheetNames.forEach(function(sheetName,+index)+{

++++++++++++//+Obtain+The+Current+Row+As+CSV
++++++++++++var+fieldsObjs+=+XLS.utils.sheet_to_json(cfb.Sheets[sheetName]);

++++++++++++fieldsObjs.map(function(field)+{
++++++++++++++++$("#my_file_output").append(''+%2B+field.Fields+%2B+'
');
++++++++++++});

++++++++});
++++}

++++oReq.send();|code-block|syntax|javascript^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|O|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|P|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|Q|9|@]|A|@]|B|$]]|$2|I|4|J|6|K|8|R|9|@]|A|@]|B|$L|M]]]]

<p>If you are ever wondering how to read a file from server this code might be helpful.</p>

<p>Restrictions :</p>

<ol>
<li>File should be in the server (Local/Remote).</li>
<li>You will have to setup headers or have CORS google plugin.</li>
</ol>

<p>
    </p>

<pre><code>&lt;Head&gt;
    &lt;script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"&gt;&lt;/script&gt;
    &lt;script lang="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.12.4/xlsx.core.min.js"&gt;&lt;/script&gt;
&lt;/head&gt;

&lt;body&gt;
    &lt;script&gt;
    /* set up XMLHttpRequest */


    // replace it with your file path in local server
    var url = "http://localhost/test.xlsx";

    var oReq = new XMLHttpRequest();
    oReq.open("GET", url, true);
    oReq.responseType = "arraybuffer";

    oReq.onload = function(e) {
        var arraybuffer = oReq.response;

        /* convert data to binary string */
        var data = new Uint8Array(arraybuffer);

        var arr = new Array();
        for (var i = 0; i != data.length; ++i) {
            arr[i] = String.fromCharCode(data[i]);
        }

        var bstr = arr.join("");

        var cfb = XLSX.read(bstr, { type: 'binary' });

        cfb.SheetNames.forEach(function(sheetName, index) {

            // Obtain The Current Row As CSV
            var fieldsObjs = XLS.utils.sheet_to_json(cfb.Sheets[sheetName]);

            fieldsObjs.map(function(field) {
                $("#my_file_output").append('&lt;input type="checkbox" value="' + field.Fields + '"&gt;' + field.Fields + '&lt;br&gt;');
            });

        });
    }

    oReq.send();
    &lt;/script&gt;
&lt;/body&gt;
&lt;div id="my_file_output"&gt;
&lt;/div&gt;

&lt;/html&gt;
</code></pre>


entityMap|blocks|key|e9nht|text|如果您想要以最简单和最细小的方式阅读|type|unstyled|depth|inlineStyleRanges|entityRanges|data|a0ra5|*|ataar|浏览器中的.xlsx文件，则此库可能会执行以下操作：|8cj3t|https://catamphetamine.github.io/read-excel-file/|bkhbs|import+readXlsxFile+from+'read-excel-file'

const+input+=+document.getElementById('input')

input.addEventListener('change',+()+=>+{
++readXlsxFile(input.files[0]).then((data)+=>+{
++++//+`data`+is+an+array+of+rows
++++//+each+row+being+an+array+of+cells.
++})
})|code-block|syntax|javascript|30e1i|在上面的例子中|djgds|是原始字符串数据。可以使用严格的模式将其解析为JSON，方法是通过传递|2btq0|论点。有关这方面的示例，请参阅API文档。|dcjc9|API文档：|2u4|http://npmjs.com/package/read-excel-file^0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|X|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|Y|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|Z|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|10|9|@]|A|@]|B|$]]|$2|I|4|J|6|K|8|11|9|@]|A|@]|B|$L|M]]|$2|N|4|O|6|7|8|12|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|13|9|@]|A|@]|B|$]]|$2|R|4|S|6|7|8|14|9|@]|A|@]|B|$]]|$2|T|4|U|6|7|8|15|9|@]|A|@]|B|$]]|$2|V|4|W|6|7|8|16|9|@]|A|@]|B|$]]]]

<p>If you want the simplest and tiniest way of reading an *.xlsx file in a browser then this library might do:</p>

<p><a href="https://catamphetamine.github.io/read-excel-file/" rel="noreferrer">https://catamphetamine.github.io/read-excel-file/</a></p>

<pre class="lang-html prettyprint-override"><code>&lt;input type="file" id="input" /&gt;
</code></pre>

<pre class="lang-js prettyprint-override"><code>import readXlsxFile from 'read-excel-file'

const input = document.getElementById('input')

input.addEventListener('change', () =&gt; {
  readXlsxFile(input.files[0]).then((data) =&gt; {
    // `data` is an array of rows
    // each row being an array of cells.
  })
})
</code></pre>

<p>In the example above <code>data</code> is raw string data.
It can be parsed to JSON with a strict schema by passing <code>schema</code> argument. See API docs for an example of that.</p>

<p>API docs:
<a href="http://npmjs.com/package/read-excel-file" rel="noreferrer">http://npmjs.com/package/read-excel-file</a></p>


entityMap|blocks|key|dddk3|text|包括xslx.js、xlsx.full.min.js、jszip.js|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6b9m4|将onchange事件处理程序添加到文件输入|83nhb|function+showDataExcel(event)
{
++++++++++++var+file+=+event.target.files[0];
++++++++++++var+reader+=+new+FileReader();
++++++++++++var+excelData+=+[];
++++++++++++reader.onload+=+function+(event)+{
++++++++++++++++var+data+=+event.target.result;
++++++++++++++++var+workbook+=+XLSX.read(data,+{
++++++++++++++++++++type:+'binary'
++++++++++++++++});

++++++++++++++++workbook.SheetNames.forEach(function+(sheetName)+{
++++++++++++++++++++//+Here+is+your+object
++++++++++++++++++++var+XL_row_object+=+XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);

++++++++++++++++++++for+(var+i+=+0;+i+<+XL_row_object.length;+i%2B%2B)
++++++++++++++++++++{
++++++++++++++++++++++++excelData.push(XL_row_object[i]["your+column+name"]);

++++++++++++++++++++}

++++++++++++++++++++var+json_object+=+JSON.stringify(XL_row_object);
++++++++++++++++++++console.log(json_object);
++++++++++++++++++++alert(excelData);
++++++++++++++++})

++++++++++++};

++++++++++++reader.onerror+=+function+(ex)+{
++++++++++++++++console.log(ex);
++++++++++++};

++++++++++++reader.readAsBinaryString(file);

}|code-block|syntax|javascript^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|K|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|L|9|@]|A|@]|B|$H|I]]]]

<p>include the xslx.js , xlsx.full.min.js , jszip.js</p>

<p>add a onchange event handler to the file input </p>

<pre><code>function showDataExcel(event)
{
            var file = event.target.files[0];
            var reader = new FileReader();
            var excelData = [];
            reader.onload = function (event) {
                var data = event.target.result;
                var workbook = XLSX.read(data, {
                    type: 'binary'
                });

                workbook.SheetNames.forEach(function (sheetName) {
                    // Here is your object
                    var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);

                    for (var i = 0; i &lt; XL_row_object.length; i++)
                    {
                        excelData.push(XL_row_object[i]["your column name"]);

                    }

                    var json_object = JSON.stringify(XL_row_object);
                    console.log(json_object);
                    alert(excelData);
                })

            };

            reader.onerror = function (ex) {
                console.log(ex);
            };

            reader.readAsBinaryString(file);

}
</code></pre>


entityMap|blocks|key|532eo|text|上传|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4ugrs|在这里，你可以把数据放进去|7i57d|格式|2bv1f|​|c60sd|var+ExcelToJSON+=+function()+{

++++++this.parseExcel+=+function(file)+{
++++++++var+reader+=+new+FileReader();

++++++++reader.onload+=+function(e)+{
++++++++++var+data+=+e.target.result;
++++++++++var+workbook+=+XLSX.read(data,+{
++++++++++++type:+'binary'
++++++++++});
++++++++++workbook.SheetNames.forEach(function(sheetName)+{
++++++++++++//+Here+is+your+object
++++++++++++var+XL_row_object+=+XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
++++++++++++var+json_object+=+JSON.stringify(XL_row_object);
++++++++++++console.log(JSON.parse(json_object));
++++++++++++jQuery(+'#xlx_json'+).val(+json_object+);
++++++++++})
++++++++};

++++++++reader.onerror+=+function(ex)+{
++++++++++console.log(ex);
++++++++};

++++++++reader.readAsBinaryString(file);
++++++};
++};

++function+handleFileSelect(evt)+{
++++
++++var+files+=+evt.target.files;+//+FileList+object
++++var+xl2json+=+new+ExcelToJSON();
++++xl2json.parseExcel(files[0]);
++}


+



++++


++++

++++
++++++++document.getElementById('upload').addEventListener('change',+handleFileSelect,+false);|code-block|syntax|javascript|c02tb|d4ftb|这是以下各项的组合|fjqdl|帖子：|e4so4|https://stackoverflow.com/a/37083658/4742733|2j6i1|https://stackoverflow.com/a/39515846/4742733|4m6ca|祝你好运。^0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|Y|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|Z|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|10|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|11|9|@]|A|@]|B|$]]|$2|I|4|J|6|K|8|12|9|@]|A|@]|B|$L|M]]|$2|N|4|H|6|7|8|13|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|14|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|15|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|16|9|@]|A|@]|B|$]]|$2|U|4|V|6|7|8|17|9|@]|A|@]|B|$]]|$2|W|4|X|6|7|8|18|9|@]|A|@]|B|$]]]]

<h1>Upload an <code>excel file</code> here and you can get the data in <code>JSON</code> format in <code>console</code>:</h1>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"&gt;&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js"&gt;&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.js"&gt;&lt;/script&gt;
&lt;script&gt;
    var ExcelToJSON = function() {

      this.parseExcel = function(file) {
        var reader = new FileReader();

        reader.onload = function(e) {
          var data = e.target.result;
          var workbook = XLSX.read(data, {
            type: 'binary'
          });
          workbook.SheetNames.forEach(function(sheetName) {
            // Here is your object
            var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
            var json_object = JSON.stringify(XL_row_object);
            console.log(JSON.parse(json_object));
            jQuery( '#xlx_json' ).val( json_object );
          })
        };

        reader.onerror = function(ex) {
          console.log(ex);
        };

        reader.readAsBinaryString(file);
      };
  };

  function handleFileSelect(evt) {
    
    var files = evt.target.files; // FileList object
    var xl2json = new ExcelToJSON();
    xl2json.parseExcel(files[0]);
  }


 
&lt;/script&gt;

&lt;form enctype="multipart/form-data"&gt;
    &lt;input id="upload" type=file  name="files[]"&gt;
&lt;/form&gt;

    &lt;textarea class="form-control" rows=35 cols=120 id="xlx_json"&gt;&lt;/textarea&gt;

    &lt;script&gt;
        document.getElementById('upload').addEventListener('change', handleFileSelect, false);

    &lt;/script&gt;</code></pre>
</div>
</div>
</p>

<p>This is a combination of the following <code>Stackoverflow</code> posts:</p>

<ol>
<li><a href="https://stackoverflow.com/a/37083658/4742733">https://stackoverflow.com/a/37083658/4742733</a></li>
<li><a href="https://stackoverflow.com/a/39515846/4742733">https://stackoverflow.com/a/39515846/4742733</a></li>
</ol>

<p>Good Luck...</p>


entityMap|blocks|key|2luod|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7e21v|var+ExcelToJSON+=+function()+{

++++++this.parseExcel+=+function(file)+{
++++++++var+reader+=+new+FileReader();

++++++++reader.onload+=+function(e)+{
++++++++++var+data+=+e.target.result;
++++++++++var+workbook+=+XLSX.read(data,+{
++++++++++++type:+'binary'
++++++++++});
++++++++++workbook.SheetNames.forEach(function(sheetName)+{
++++++++++++//+Here+is+your+object
++++++++++++var+XL_row_object+=+XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
++++++++++++var+json_object+=+JSON.stringify(XL_row_object);
++++++++++++console.log(JSON.parse(json_object));
++++++++++++jQuery(+'#xlx_json'+).val(+json_object+);
++++++++++})
++++++++};

++++++++reader.onerror+=+function(ex)+{
++++++++++console.log(ex);
++++++++};

++++++++reader.readAsBinaryString(file);
++++++};
++};

++function+handleFileSelect(evt)+{
++++
++++var+files+=+evt.target.files;+//+FileList+object
++++var+xl2json+=+new+ExcelToJSON();
++++xl2json.parseExcel(files[0]);
++}


+



++++


++++

++++
++++++++document.getElementById('upload').addEventListener('change',+handleFileSelect,+false);|code-block|syntax|javascript|cfabu^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|I|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|J|9|@]|A|@]|B|$F|G]]|$2|H|4|5|6|7|8|K|9|@]|A|@]|B|$]]]]

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"&gt;&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js"&gt;&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.js"&gt;&lt;/script&gt;
&lt;script&gt;
    var ExcelToJSON = function() {

      this.parseExcel = function(file) {
        var reader = new FileReader();

        reader.onload = function(e) {
          var data = e.target.result;
          var workbook = XLSX.read(data, {
            type: 'binary'
          });
          workbook.SheetNames.forEach(function(sheetName) {
            // Here is your object
            var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
            var json_object = JSON.stringify(XL_row_object);
            console.log(JSON.parse(json_object));
            jQuery( '#xlx_json' ).val( json_object );
          })
        };

        reader.onerror = function(ex) {
          console.log(ex);
        };

        reader.readAsBinaryString(file);
      };
  };

  function handleFileSelect(evt) {
    
    var files = evt.target.files; // FileList object
    var xl2json = new ExcelToJSON();
    xl2json.parseExcel(files[0]);
  }


 
&lt;/script&gt;

&lt;form enctype="multipart/form-data"&gt;
    &lt;input id="upload" type=file  name="files[]"&gt;
&lt;/form&gt;

    &lt;textarea class="form-control" rows=35 cols=120 id="xlx_json"&gt;&lt;/textarea&gt;

    &lt;script&gt;
        document.getElementById('upload').addEventListener('change', handleFileSelect, false);

    &lt;/script&gt;</code></pre>
</div>
</div>
</p>


entityMap|blocks|key|11bot|text|谢谢你上面的回答，我认为(答案的)范围已经完成了，但我想为使用react的人添加一个"react方式“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|9vnua|创建一个名为importData.js的文件：|5s8qt|import+React,+{Component}+from+'react';
import+XLSX+from+'xlsx';
export+default+class+ImportData+extends+Component{
++++constructor(props){
++++++++super(props);
++++++++this.state={
++++++++++++excelData:{}
++++++++}
++++}
++++excelToJson(reader){
++++++++var+fileData+=+reader.result;
++++++++var+wb+=+XLSX.read(fileData,+{type+:+'binary'});
++++++++var+data+=+{};
++++++++wb.SheetNames.forEach(function(sheetName){
+++++++++++++var+rowObj+=XLSX.utils.sheet_to_row_object_array(wb.Sheets[sheetName]);
+++++++++++++var+rowString+=+JSON.stringify(rowObj);
+++++++++++++data[sheetName]+=+rowString;
++++++++});
++++++++this.setState({excelData:+data});
++++}
++++loadFileXLSX(event){
++++++++var+input+=+event.target;
++++++++var+reader+=+new+FileReader();
++++++++reader.onload+=+this.excelToJson.bind(this,reader);
++++++++reader.readAsBinaryString(input.files[0]);
++++}
++++render(){
++++++++return+(
++++++++++++
++++++++);
++++}
}|code-block|syntax|javascript|es50l|然后，您可以在render方法中使用该组件，如下所示：|4oc26|import+ImportData+from+'./importData.js';
import+React,+{Component}+from+'react';
class+ParentComponent+extends+Component{
++++render(){
++++++++return+();
++++}
}|et5hn|将数据设置为自己的状态，则可以通过以下方式访问“父组件”中的Excel数据|dp3tg|这个^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|S|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|T|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|U|9|@]|A|@]|B|$]]|$2|L|4|M|6|G|8|V|9|@]|A|@]|B|$H|I]]|$2|N|4|O|6|7|8|W|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|X|9|@]|A|@]|B|$]]]]

<p>Thank you for the answer above, I think the scope (of answers) is completed but I would like to add a &quot;react way&quot; for whoever using react.</p>
<p><strong>Create a file called importData.js:</strong></p>
<pre><code>import React, {Component} from 'react';
import XLSX from 'xlsx';
export default class ImportData extends Component{
    constructor(props){
        super(props);
        this.state={
            excelData:{}
        }
    }
    excelToJson(reader){
        var fileData = reader.result;
        var wb = XLSX.read(fileData, {type : 'binary'});
        var data = {};
        wb.SheetNames.forEach(function(sheetName){
             var rowObj =XLSX.utils.sheet_to_row_object_array(wb.Sheets[sheetName]);
             var rowString = JSON.stringify(rowObj);
             data[sheetName] = rowString;
        });
        this.setState({excelData: data});
    }
    loadFileXLSX(event){
        var input = event.target;
        var reader = new FileReader();
        reader.onload = this.excelToJson.bind(this,reader);
        reader.readAsBinaryString(input.files[0]);
    }
    render(){
        return (
            &lt;input type=&quot;file&quot; onChange={this.loadFileXLSX.bind(this)}/&gt;
        );
    }
}
</code></pre>
<p><strong>Then you can use the component in the render method like:</strong></p>
<pre><code>import ImportData from './importData.js';
import React, {Component} from 'react';
class ParentComponent extends Component{
    render(){
        return (&lt;ImportData/&gt;);
    }
}
</code></pre>
<p><code>&lt;ImportData/&gt;</code> would set the data to its own state, you can access Excel data in the &quot;parent component&quot; by following <a href="https://towardsdatascience.com/passing-data-between-react-components-parent-children-siblings-a64f89e24ecf" rel="nofollow noreferrer">this</a>:</p>


entityMap|blocks|key|1uh49|text|这是针对react+js的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|41lnh|import+React,+{+useState+}+from+"react";
import+logo+from+"./logo.svg";
import+"./App.css";
import+*+as+XLSX+from+"xlsx";

function+App()+{
++const+[items,+setItems]+=+useState([]);

++const+readExcel+=+(file)+=>+{
++++const+promise+=+new+Promise((resolve,+reject)+=>+{
++++++const+fileReader+=+new+FileReader();
++++++fileReader.readAsArrayBuffer(file);

++++++fileReader.onload+=+(e)+=>+{
++++++++const+bufferArray+=+e.target.result;

++++++++const+wb+=+XLSX.read(bufferArray,+{+type:+"buffer"+});

++++++++const+wsname+=+wb.SheetNames[0];

++++++++const+ws+=+wb.Sheets[wsname];

++++++++const+data+=+XLSX.utils.sheet_to_json(ws);

++++++++resolve(data);
++++++};

++++++fileReader.onerror+=+(error)+=>+{
++++++++reject(error);
++++++};
++++});

++++promise.then((d)+=>+{
++++++setItems(d);
++++});
++};

++return+(
++++
+++++++{
++++++++++const+file+=+e.target.files[0];
++++++++++readExcel(file);
++++++++}}
++++++/>

++++++
++++++++++{items.map((d)+=>+(
++++++++++++
++++++++++))}
++++++++
++++++++
++++++++++
++++++++++++Item
++++++++++++Description
++++++++++
++++++++
++++++++
++++++++++++++{d.Item}
++++++++++++++{d.Description}
++++++++++++
++++++
++++
++);
}

export+default+App;|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

<p><strong>This is for react js</strong></p>
<pre><code>import React, { useState } from &quot;react&quot;;
import logo from &quot;./logo.svg&quot;;
import &quot;./App.css&quot;;
import * as XLSX from &quot;xlsx&quot;;

function App() {
  const [items, setItems] = useState([]);

  const readExcel = (file) =&gt; {
    const promise = new Promise((resolve, reject) =&gt; {
      const fileReader = new FileReader();
      fileReader.readAsArrayBuffer(file);

      fileReader.onload = (e) =&gt; {
        const bufferArray = e.target.result;

        const wb = XLSX.read(bufferArray, { type: &quot;buffer&quot; });

        const wsname = wb.SheetNames[0];

        const ws = wb.Sheets[wsname];

        const data = XLSX.utils.sheet_to_json(ws);

        resolve(data);
      };

      fileReader.onerror = (error) =&gt; {
        reject(error);
      };
    });

    promise.then((d) =&gt; {
      setItems(d);
    });
  };

  return (
    &lt;div&gt;
      &lt;input
        type=&quot;file&quot;
        onChange={(e) =&gt; {
          const file = e.target.files[0];
          readExcel(file);
        }}
      /&gt;

      &lt;table class=&quot;table container&quot;&gt;
        &lt;thead&gt;
          &lt;tr&gt;
            &lt;th scope=&quot;col&quot;&gt;Item&lt;/th&gt;
            &lt;th scope=&quot;col&quot;&gt;Description&lt;/th&gt;
          &lt;/tr&gt;
        &lt;/thead&gt;
        &lt;tbody&gt;
          {items.map((d) =&gt; (
            &lt;tr key={d.Item}&gt;
              &lt;th&gt;{d.Item}&lt;/th&gt;
              &lt;td&gt;{d.Description}&lt;/td&gt;
            &lt;/tr&gt;
          ))}
        &lt;/tbody&gt;
      &lt;/table&gt;
    &lt;/div&gt;
  );
}

export default App;
</code></pre>


entityMap|blocks|key|6o8nl|text|readExcelFile+=+async+(+file+)+=>
{

++++const+fileReader+=+new+FileReader();
++++fileReader.readAsArrayBuffer(+file+);

++++fileReader.onload+=+(+e+)+=>
++++{
++++++++const+bufferArray+=+e.target.result;

++++++++const+wb+=+XLSX.read(+bufferArray,+{+type:+"buffer"+}+);

++++++++const+wsname+=+wb.SheetNames[+0+];

++++++++const+ws+=+wb.Sheets[+wsname+];

++++++++const+data+=+XLSX.utils.sheet_to_json(+ws+);
++++++++console.log(data);
++++};

};|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript^0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$C|D]]]]

<pre><code>readExcelFile = async ( file ) =&gt;
{

    const fileReader = new FileReader();
    fileReader.readAsArrayBuffer( file );

    fileReader.onload = ( e ) =&gt;
    {
        const bufferArray = e.target.result;

        const wb = XLSX.read( bufferArray, { type: &quot;buffer&quot; } );

        const wsname = wb.SheetNames[ 0 ];

        const ws = wb.Sheets[ wsname ];

        const data = XLSX.utils.sheet_to_json( ws );
        console.log(data);
    };

};
            &lt;input type=&quot;file&quot; name=&quot;excelfile&quot; id=&quot;excelfile&quot;  readExcelFile(file)&gt;
</code></pre>


<p>I am able to read Excel file via <code>FileReader</code> but it outputs text as well as weird characters with it. I need to read <code>xls</code> file row-wise, read data in every column and convert it to JSON. </p>

<p>How to read xls file row by row?</p>


How to parse Excel (XLS) file in Javascript/HTML5

数据转换

服务器

jQuery

HTML5

JSON

 我可以通过以下方式读取Excel文件 但是它输出文本和奇怪的字符。我需要阅读 文件行方式，读取每一列中的数据并将其转换为JSON。 如何逐行读取xls文件？

问如何在Javascript/HTML5中解析Excel (XLS)文件
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Javascript/HTML5中解析Excel (XLS)文件EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Javascript/HTML5中解析Excel (XLS)文件
EN