1， js 读取表格数据 并转化为数组
 

<script src="home/js/jquery.min.js"></script><script src="home/js/xlsx.core.min.js"></script>
    <script type="text/javascript">           var mArr = '';        // 从网络上读取某个excel文件，url必须同域，否则报错        function readWorkbookFromRemoteFile(url, callback) {            var xhr = new XMLHttpRequest();            xhr.open('get', url, true);            xhr.responseType = 'arraybuffer';            xhr.onload = function (e) {                if (xhr.status == 200) {                    var data = new Uint8Array(xhr.response)                    var workbook = XLSX.read(data, {                        type: 'array'                    });                    if (callback) callback(workbook);                }            };            xhr.send();        };        function readWorkbook(workbook) {            var sheetNames = workbook.SheetNames; // 工作表名称集合            var worksheet = workbook.Sheets[sheetNames[0]]; // 这里我们只读取第一张sheet            // var csv = XLSX.utils.sheet_to_csv(worksheet);             const sheet2JSONOpts = {                    /** Default value for null/undefined values */                    defval: ''//给defval赋值为空的字符串            }            //JSON.stringify(            var csv = XLSX.utils.sheet_to_json(worksheet);            console.log(csv[0]["__EMPTY"]);            document.getElementById('result').innerHTML = csv[0]["__EMPTY"];            // document.getElementById('result').innerHTML = csv2table(csv);        }        function loadRemoteFile(url) {            readWorkbookFromRemoteFile(url, function (workbook) {                // console.log(workbook);                readWorkbook(workbook);            });        }        loadRemoteFile('/Excel/*.xlsx')</script>