js读取excel

最新推荐文章于 2024-03-22 20:49:10 发布

simplyou

最新推荐文章于 2024-03-22 20:49:10 发布

阅读量523

点赞数

分类专栏： IT

本文链接：https://blog.csdn.net/simplyou/article/details/117566944

版权

IT 专栏收录该内容

83 篇文章 1 订阅

订阅专栏

技术交流QQ群 933925017

1.下载 excel库

地址 https://github.com/SheetJS/js-xlsx

2.编写代码引入`jq` 和`excel-core`

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <script src="js/xlsx.core.min.js"></script>
    <script src="js/jquery.min.js"></script>
</head>
<body>
<input id="file" type="file">
<p>
    <button>写入所号</button>
</p>
<script>
    var list = [];
    // 读取本地excel文件
    function readWorkbookFromLocalFile(file, callback) {
        var reader = new FileReader();
        reader.onload = function(e) {
            var data = e.target.result;
            var wb = XLSX.read(data, {type: 'binary'});
            var text = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]);
            if(callback) callback(text);
        };
        reader.readAsBinaryString(file);
    }
    $("#file").change(function () {
        if(!this.files) {
            return;
        }
        var f = this.files[0];
        readWorkbookFromLocalFile(f,function (value) {
            list = value;
        })
    })
    $('button').click(function () {
        // 发送网络请求
        var s = '';
        for (const x of list) {
            // console.log(x)
            s = s + 'list_num[]=' + x.num + "&";
        }
        s = s.substring(0,s.length-1);
        console.log(s);
        var url = `http://localhost/guicheng/public/api/import_white?${s}`;
        $.get(url,{},function (res) {
            console.log(res)
        },'json')
    })
</script>
</body>
</html>