File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
<meta name="description" content="Export with customisable file name" />
    <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.12.1/b-2.2.3/b-html5-2.2.3/datatables.min.css"/>
 
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.12.1/b-2.2.3/b-html5-2.2.3/datatables.min.js"></script>
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
<table id="example" class="display" cellspacing="0" width="100%">
  <thead>
    <tr>
      <th>Id</th>
      <th>Name</th>
    </tr>
  </thead>
  <tfoot>
    <tr>
      <th>Id</th>
      <th>Name</th>
    </tr>
  </tfoot>
  <tbody>
    <tr>
      <td>8335201430007628</td>
      <td>A</td>
    </tr>
    <tr>
      <td>8335201430210032</td>
      <td>B</td>
    </tr>
​
  </tbody>
</table>
​
    </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() {
​
  $('#example').DataTable({
    dom: 'Bfrtip',
    buttons: [{
      extend: 'excelHtml5',
      title: 'Transaction',
      customizeData: function(data) {
        for(var i = 0; i < data.body.length; i++) {
          for(var j = 0; j < data.body[i].length; j++) {
            data.body[i][j] = '\u200C' + data.body[i][j];
          }
        }
      },      
      orientation: 'landscape'
    }]
  });
});
Output 300px

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

Dismiss x
public
Bin info
anonymouspro
0viewers