WebDataRocks在线电子表格excel处理插件demo

代码语言:html

所属分类:其他

代码描述:WebDataRocks在线电子表格excel处理插件demo

代码标签: 表格 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