WebDataRocks在线电子表格excel处理插件demo
代码语言:html
所属分类:其他
代码描述:WebDataRocks在线电子表格excel处理插件demo
下面为部分代码预览,完整代码请点击下载或在bfwstudio webide中打开
<!DOCTYPE html>
<html>
<head>
<title>WebDataRocks</title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link type="text/css" rel="stylesheet" href="http://repo.bfw.wiki/bfwrepo/css/webdatarocks.min.css">
<script type="text/javascript" src="http://repo.bfw.wiki/bfwrepo/js/webdatarocks.js"></script>
<script type="text/javascript" src="http://repo.bfw.wiki/bfwrepo/js/webdatarocks.toolbar.min.js"></script>
<script type="text/javascript" src="http://repo.bfw.wiki/bfwrepo/js/chart.js"></script>
</head>
<body>
<div id="wdr-component"></div>
<div id="wdr-component2"></div>
<canvas id="polar-chart"></canvas>
<script>
var pivot = new WebDataRocks({
container: "#wdr-component",
toolbar: true,
report: {
dataSource: {
filename: "https://cdn.webdatarocks.com/data/data.csv"
}
}
});
var pivot2 = new WebDataRocks({
container: "#wdr-component2", toolbar: true, height: 580, width: 900, report: {
dataSource: {
data: getData()}, slice: {
reportFilters: [{
uniqueName: "Date.Month"
}], rows: [{
uniqueName: "Country"
}, {
uniqueName: "Product Category"
}], columns: [{
uniqueName: "Measures"
}], measures: [{
uniqueName: "Profit", aggregation: "sum"
}, {
uniqueName: "Budgeted Expenses", aggregation: "sum"
}, {
uniqueName: "Actual Expenses", aggregation: "sum"
}], expands: {
rows: [{
tuple: ["Country.France"]}, {
tuple: ["Country.Spain"]}]}}, conditions: [{
formula: "#value > 15000", measure: "Profit", format: {
backgroundColor: "#9CCC65", color: "#000000", fontFamily: "Arial", fontSize: "12px"
}}, {
formula: "#value > 3000", measure: "Actual Expenses", format: {
backgroundColor: "#F44336", color: "#000000", fontFamily: "Arial", fontSize: "12px"
}}]}, reportcomplete: function() {
createPolarChart()}});
var chart;
function createPolarChart() {
webdatarocks.getData({
.........完整代码请登录后点击上方下载按钮下载查看
网友评论0