java script_js解析Excel文件，解析后的数据用Echarts折线图展示
把excel文件导入后，转换成jason格式，在网页显示
转换成json格式写个数据重组然后传给echarts生成图形
https://blog.csdn.net/qq_28529373/article/details/78531395
js解析Excel
$('#excel-file').change(function(e){
var files = e.target.files;
var fileReader = new FileReader();
fileReader.onload = function(ev){
try {
var data = ev.target.result,
//以二进制流方式读取得到整份excel表格对象
workbook = XLSX.read(data, {type : 'binary'}),
persons = [];//存储获取到的数据
} catch (e) {
console.log('文件类型不正确');
return;
}
//表格的表格范围，可用于判断表头数量是否正确
var fromTo = '';
//遍历每张表读取
for (var sheet in workbook.Sheets) {
if (workbook.Sheets.hasOwnProperty(sheet)) {
fromTo = workbook.Sheets[sheet]['!ref'];
console.log(fromTo);
persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet]));
//break; //如果只取第一张表，就取消注释这行
}
}
debugger;
console.log(persons);
var chart = echarts.init(document.getElementById('demo'));
var data2 = [];
for(var i = 0; i
![]()
1665060526
查看更多评论
