File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
​
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.11.3/b-2.1.1/b-html5-2.1.1/b-print-2.1.1/datatables.min.css"/>
 
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.11.3/b-2.1.1/b-html5-2.1.1/b-print-2.1.1/datatables.min.js"></script>
    
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
​
    </div>
  </body>
</html>
CSSSaved
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
​
JavaScriptSaved
 
$(document).ready( function () {
  
  var fileName = 'test';
  var tab_data_Pop = [
    ['a', 'b', 1, 2, 3, 4, 5, 6, 7, 8]
  ];
  var tab_data_Gr = [
    ['c', 'd', 1, 2, 3, 4, 5, 6, 7, 8]
  ];
  
  var labels = [
    {title: 'col1'},
    {title: 'col2'},
    {title: 'col3'},
    {title: 'col4'},
    {title: 'col5'},
    {title: 'col6'},
    {title: 'col7'},
    {title: 'col8'},
    {title: 'col9'},
    {title: 'col10'},
  ]
  
  
  var outDiv1 = '.container';
  $(outDiv1).append("<table id='growthtab1' class='DTTable' width='100%'></table>");
$(outDiv1).append("<table id='growthtab2' class='DTTable' width='100%'></table>");
​
 $("#growthtab1").DataTable( {
    "columnDefs" : [
    {'targets' : [2, 3, 4, 5, 6, 7, 8], 'type' : 'num',
    render: DataTable.render.number( ',', '.', 0, '','' )},
    {  
        'targets': [0,1], 'className': 'dt-body-left',
        'targets' : [2, 3, 4, 5, 6, 7, 8], 'className': 'dt-body-right'
    },
    { 'targets': 1, 'width': '20%' ,
      'targets' : [2, 3, 4, 5, 6, 7, 8], 'width' :'10%'
    } 
    ],
    dom: 'Bfrtip',
   buttons: [
    /*{ 
            extend: 'word',
            text :'Word',
            titleAttr: fileName,
            footer : true
        },*/
        { 
            extend: 'excelHtml5',
            title: fileName,
            footer : true
        },
        {
            extend: 'csvHtml5',
            title: fileName,
            footer : true
        },
        {
            extend: 'pdfHtml5',
            title: fileName,
            footer : true
        }
    ],
    "order": [],
    data: tab_data_Pop,
    columns : labels
} );
 
$("#growthtab2").DataTable( {
    "columnDefs" : [
    {'targets' : [2, 3, 4, 5, 6, 7, 8], 'type' : 'num',
    render: DataTable.render.number( '', '.', 1, '','%' )},
    {  
        'targets': [0,1], 'className': 'dt-body-left',
        'targets' : [2, 3, 4, 5, 6, 7, 8], 'className': 'dt-body-right'
    },
    { 'targets': 1, 'width': '20%' ,
      'targets' : [2, 3, 4, 5, 6, 7, 8], 'width' :'10%'
    } 
    ],
    dom: 'Bfrtip',
   buttons: [
    /*{ 
            extend: 'word',
            text :'Word',
            titleAttr: fileName,
            footer : true
        },*/
        { 
            extend: 'excelHtml5',
            title: fileName,
            footer : true
        },
        {
            extend: 'csvHtml5',
            title: fileName,
            footer : true
        },
        {
            extend: 'pdfHtml5',
            title: fileName,
            footer : true
        }
    ],
    "order": [],
    data: tab_data_Gr,
    columns : labels
} );
} );
​
Output 300px

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers