js读取excel文件获取表头，及表头长度范围筛选

本文链接：https://blog.youkuaiyun.com/qq_33267306/article/details/137109503

本文介绍如何使用JavaScript库（如JS-XLSX）处理上传的Excel文件，解析数据并筛选特定月份的数据。代码示例展示了文件读取、数据转换和条件过滤的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <script src="https://cdn.jsdelivr.net/npm/xlsx/dist/xlsx.full.min.js"></script>
    <script src="https://cdn.bootcss.com/FileSaver.js/2014-11-29/FileSaver.js"></script>
    <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/echarts@5.5.0/dist/echarts.min.js"></script>
    <title>数据分析</title>
</head>
<style>
    #container{
        width: 180vh;
        height: 80vh;
        margin: 0 auto;
    }
    .button-container {
  display: flex;
  justify-content: center;
}
button {
  margin-left: 10%;
  margin-right: 10%;
  width: 18vh;
  height: 6vh;
}

            
</style>
<body style="background-color: #f1eedb;"> 
    <input type="file" id="inputFile" onchange="selectFolder()" name="csvfiles" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel" />
<hr>

<div id="container"></div>
</body>

<script>
    function selectFolder() {
    var file = document.getElementById("inputFile").files[0]; //获取上传的文件
    //获取文件名
    filename = file.name.split('.')[0];
    console.log(file);
    var reader = new FileReader(); //新建一个FileReader对象
    reader.readAsBinaryString(file); //读取文件
    reader.onload = function(e) {
        var workbook = XLSX.read(e.target.result, {type: 'binary'}); //使用JS-XLSX库解析文件
        var sheetNames = workbook.SheetNames; //获取Excel中所有的Sheet名称
        var worksheet = workbook.Sheets[sheetNames[0]]; //获取第1个Sheet的值
        data = XLSX.utils.sheet_to_json(worksheet); //将单元格数据转成JSON
        //this.importFileForm = constructData(data);
        console.log(data); //打印输出数据\
        ///这个就是获取表头Object.keys(obj);
        const headers = Object.keys(data[0]);
        console.log(headers);

        var p =data.filter(data => data.month===9 && data.cq===2);
        console.log(p);
        }
       
        
    }


    
</script>


</html>

一个数组的长度范围是：arr.length >= min && arr.length <= max;