读取双脚文件

cshenfu

2023-03-10 03eca275f9c02c442e7c841f43d8d93fb1c767ec

读取双脚文件

 read_com/css/style.css

@@ -559,7 +559,7 @@
    border: 1px solid black;
}

#chart-container {
#chart-container,#chart-container2 {
    position: relative;
    height: 1500px;
    width: 1500px;

 read_com/index.html

@@ -31,7 +31,8 @@
      <button class="last" disabled="disabled">上一帧</button>
      <button class="next" disabled="disabled">下一帧</button>
      <button class="download" disabled="disabled">保存文件</button>
      <input type="file" id="excel-file">
      <label>左脚：<input type="file" id="excel-file-left"></label>
      <label>右脚：<input type="file" id="excel-file-right"></label>
  </div>

   </div>
@@ -400,13 +401,14 @@

<div id="chart-container"></div>


</div>
<script src="./js/3d_data.js"></script>
<script src="./js/echarts.min.js"></script>
<script src="./js/echarts.gl.min.js"></script>
<script src="./js/charts.js"></script>
<script src="./js/region.js"></script>
<!-- <script src="./js/function.js"></script> -->
<script src="./js/function2.js"></script>
<script src="./js/function.js"></script>
<!-- <script src="./js/function2.js"></script> -->
  </body>
</html>

 read_com/js/function.js

@@ -776,8 +776,6 @@
                    data_map2.data[i].value = parseInt(data_end_right[i])
                    data_map2.data[i].radius = parseInt(data_end_right[i])<10?0:50
                }
                heatmapInstance.setData(data_map);
                heatmapInstance2.setData(data_map2);
            }else if(arr_arr.length == 0&&arr_arr2.length!=0){
                step = 0
                step2 == arr_arr2.length-1?arr_arr2.length-1:step2++
@@ -785,17 +783,17 @@
                    data_map.data[i].value = data_end_left[i]
                    data_map.data[i].radius = data_end_left[i]<10?0:50
                }
                heatmapInstance.setData(data_map);
            }else if(arr_arr2.length == 0&&arr_arr.length!=0){
                step2 = 0
                step == arr_arr.length-1?arr_arr.length-1:step++
                for(let i=0;i<data_map2.data?.length;i++){
                    data_map2.data[i].value = data_end_right[i]
                    data_map2.data[i].radius = data_end_right[i]<10?0:50
                    heatmapInstance2.setData(data_map2);
                }
            }

                }
            }
            heatmapInstance.setData(data_map);
            heatmapInstance2.setData(data_map2);
            for(let i=0;i<arr_arr[step]?.data.length;i++){
                    for(let x=0;x<arr_arr[step].data[i].length;x++){
                        let id_end = trueID(i)
@@ -978,21 +976,20 @@
                data_map2.data[i].value = data_end_right[i]
                data_map2.data[i].radius = data_end_right[i]<10?0:50
            }
            heatmapInstance.setData(data_map);
            heatmapInstance2.setData(data_map2);
           
        }else if(arr_arr.length == 0&&arr_arr2.length!=0){
            for(let i=0;i<data_map.data?.length;i++){
                data_map.data[i].value = data_end_left[i]
                data_map.data[i].radius = data_end_left[i]<10?0:50
            }
            heatmapInstance.setData(data_map);
        }else if(arr_arr2.length == 0&&arr_arr.length!=0){
            for(let i=0;i<data_map2.data?.length;i++){
                data_map2.data[i].value = data_end_right[i]
                data_map2.data[i].radius = data_end_right[i]<10?0:50
            }
        }
        heatmapInstance.setData(data_map);
                heatmapInstance2.setData(data_map2);
            }
        }
        for(let i=0;i<arr_arr[step]?.data.length;i++){
            for(let x=0;x<arr_arr[step].data[i].length;x++){
                let id_end = trueID(i)
@@ -1152,8 +1149,6 @@
                data_map2.data[i].value = data_end_right[i]
                data_map2.data[i].radius = data_end_right[i]<10?0:50
            }
            heatmapInstance.setData(data_map);
            heatmapInstance2.setData(data_map2);
        }else if(arr_arr.length == 0&&arr_arr2.length!=0){
            step = 0
            step2 == arr_arr2.length-1?arr_arr2.length-1:step2++
@@ -1161,16 +1156,16 @@
                data_map.data[i].value = data_end_left[i]
                data_map.data[i].radius = data_end_left[i]<10?0:50
            }
            heatmapInstance.setData(data_map);
        }else if(arr_arr2.length == 0&&arr_arr.length!=0){
            step2 = 0
            step == arr_arr.length-1?arr_arr.length-1:step++
            for(let i=0;i<data_map2.data?.length;i++){
                data_map2.data[i].value = data_end_right[i]
                data_map2.data[i].radius = data_end_right[i]<10?0:50
            }
        }
        heatmapInstance.setData(data_map);
                heatmapInstance2.setData(data_map2);
            }
        }
        for(let i=0;i<arr_arr[step]?.data.length;i++){
            for(let x=0;x<arr_arr[step].data[i].length;x++){
                let id_end = trueID(i)
@@ -1328,7 +1323,49 @@


    //给input标签绑定change事件，一上传选中的.xls文件就会触发该函数
    $('#excel-file').change(function(e) {
    $('#excel-file-left').change(function(e) {
        read_file = false
        arr_arr2 = []
        var files2 = e.target.files;
        var fileReader2 = new FileReader();
            fileReader2.onload = function(ev) {
                try {
                    var data2 = ev.target.result
                    var workbook2 = XLSX.read(data2, {
                            type: 'binary'
                        }) // 以二进制流方式读取得到整份excel表格对象
                    var persons2 = []; // 存储获取到的数据
                } catch (e) {
                    console.log('文件类型不正确',e);
                    return;
                }
        
                // 表格的表格范围，可用于判断表头是否数量是否正确
                var fromTo2 = '';
                // 遍历每张表读取
                for (var sheet2 in workbook2.Sheets) {
                    if (workbook2.Sheets.hasOwnProperty(sheet2)) {
                        fromTo2 = workbook2.Sheets[sheet2]['!ref'];//读取的全部数据 A1:AN203
                        persons2 = persons2.concat(XLSX.utils.sheet_to_json(workbook2.Sheets[sheet2], {header:1,defval:''}));//合并数据
                        // break; // 如果只取第一张表，就取消注释这行
                    }
                }
                //在控制台打印出来表格中的数据
                for(let i=0;i<persons2.length;i++){
                    persons2[i].length = 112
                    let data_ee = fun(persons2[i],28)
                    arr_arr2.push({"data":data_ee})
                }
                $('.last').attr('disabled',false)
                $('.next').attr('disabled',false)
                $('.back').attr('disabled',false) //开启回放功能
                $('.download').attr('disabled',true)
                text=persons2;//训练数据集text
        };
        // 以二进制方式打开文件
        fileReader2.readAsBinaryString(files2[0]);
    });
    $('#excel-file-right').change(function(e) {
        read_file = false
        arr_arr = []
        var files = e.target.files;
@@ -1370,3 +1407,4 @@
        // 以二进制方式打开文件
        fileReader.readAsBinaryString(files[0]);
    });