```html
<!--这是一个网上关于读取Excel最经典的代码-->
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>ECharts</title>
<!-- 引入 echarts.js -->
<!-- <script src="newjs/js/incubator-echarts-4.8.0/dist/echarts.min.js"></script> -->
<script src="js/echarts.min.js"></script>
<script src="https://blog-static.cnblogs.com/files/xieyongbin/xlsx.full.min.js"></script>
<script src="https://cdn.staticfile.org/jquery/2.0.0/jquery.min.js"></script>
</head>
<body>
<form>
<input type="file" name="file" onchange="readWorkbookFromLocalFile(this.files[0])" />
</form>
<div id="main" style="width: 800px;height:350px;"></div>
<script type="text/javascript">
// 读取本地excel文件
function readWorkbookFromLocalFile(file) {
var reader = new FileReader();
reader.onload = function (e) {
var data = e.target.result;
var workbook = XLSX.read(data, { type: 'binary' });
handle(workbook);
};
reader.readAsBinaryString(file);
}
// 处理excel文件
var date1 = [];
var date2 = [];
function handle(workbook) {
// workbook.SheetNames[0] excel第一个sheet
var datas = XLSX.utils.sheet_to_json(workbook.Sheets[workbook.SheetNames[0]]);
var title = [];
if (datas.length > 0) {
// 获取列名是汇总列名,避免某行某个字段没有值,会缺少字段
// 标题
// 获取每行数据
first:
for (var index in datas) { // datas数组,index为索引
second:
for (var key in datas[index]) { // datas[index]对象,key为键
if (-1 === title.indexOf(key)) {
title.push(key);
}
}
}
for (var i = 0; i < datas.length; i++) {
var a = datas[i].time * 24;//time为第一列的名字
var b = (a - parseInt(a)) * 60;
var c = (b - parseInt(b)) * 60;
date1[i] = parseInt(a).toString() + ":" + parseInt(b).toString() + ":" + parseInt(c).toString();
date2[i] = datas[i].sum1;//sum1为第二列的名字
}
aaa();
}
}
</script>
<script type="text/javascript">
function aaa() {
var myChart = echarts.init(document.getElementById('main'));
option = {
tooltip: {
trigger: 'axis',
position: function (pt) {
return [pt[0], '10%'];
}
},
title: {
left: 'center',
text: '大数据量面积图',
},
xAxis: {
type: 'category',
boundaryGap: false,
data: date1
},
yAxis: {
type: 'value',
},
dataZoom: [{
type: 'inside',
start: 0,
end: 100
}],
series: [
{
name: '人流量',
type: 'line',
smooth: true,
symbol: 'none',
itemStyle: {
color: 'rgb(255, 70, 131)'
},
data: date2
}
]
};
myChart.setOption(option);
}
</script>
</body>
</html>
这是excel里面的数据
该方法是通过input选择excel文件最终生成echarts的,
但是我想把excel文件路径直接写在代码里面,
然后直接生成echarts图表,不需要通过input导入,该怎么写呢?