1.创建index文件
<!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">
<title>Document</title>
<script src="./jquery.min.js"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="./echarts.js"></script>
</head>
<body>
<div id="chart" style="width:900px; height:500px;"></div>
<script type='text/javascript'>
var myChart = echarts.init(document.getElementById('chart'));
// var chartDom = echarts.init(chartDom);
var option;
option = {
xAxis: {
type: 'category',
data: []
},
yAxis: {
type: 'value'
},
series: [
{
data: [],
type: 'bar'
},
{
data: [],
type: 'bar'
}
]
};
$.ajax({
method: "GET",
url: "./shuju.json",
dataType: "json",
success: function (e) {
for (var i = 0; i < e.length; i++) {
console.log();
option.xAxis.data.push(e[i].date);
option.series[0].data.push(e[i].milk);
option.series[1].data.push(e[i].bread);
myChart.setOption(option);
}
// option.xAxis.data = e.date;
// option.series[0].data = e.;
// option.series[1].data = e.;
//
}
});
</script>
</body>
</html>
2.安装python,创建py文件
import pandas as pd
# Excel文件路径
excel_file = './shuju.xlsx'
# 输出的JSON文件路径
json_file = './shuju.json'
# 读取Excel文件
df = pd.read_excel(excel_file)
# 将DataFrame转换为JSON
json_data = df.to_json(orient='records')
# 写入JSON文件
with open(json_file, 'w', encoding='utf-8') as f:
f.write(json_data)
print(f"Excel文件已成功转换为{json_file}")