File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
    <link href="https://cdn.datatables.net/v/dt/jszip-3.10.1/dt-2.1.8/b-3.1.2/b-colvis-3.1.2/b-html5-3.1.2/datatables.min.css" rel="stylesheet">
 
    <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
    <script src="https://nightly.datatables.net/js/dataTables.js?2024-10-23"></script>
    <script src="https://cdn.datatables.net/v/dt/jszip-3.10.1/b-3.1.2/b-colvis-3.1.2/b-html5-3.1.2/datatables.min.js"></script>
    
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
   <table id="example" class="display nowrap" width="100%">
      <thead>
      <tr>
         <th rowspan="2">Name</th>
         <th rowspan="2" class="noExport">Position</th>
         <th colspan="3" class="noColvis">Values</th>
         <th rowspan="2">Location</th>
      </tr>
      <tr>
         <th class="noExport">Val1</th>
         <th class="noColvis">Val2</th>
         <th>Val3</th>
      </tr>
      </thead>
 
      <tbody>
      <tr>
         <td>Tiger Nixon</td>
         <td>System Architect</td>
         <td>0.5</td>
         <td>123</td>
         <td>61</td>
         <td>Edinburgh</td>
      </tr>
      <tr>
         <td>Garrett Winters</td>
         <td>Director</td>
         <td>0.5</td>
         <td>456</td>
         <td>63</td>
         <td>Edinburgh</td>
      </tr>
      <tr>
         <td>Ashton Cox</td>
         <td>Technical Author</td>
         <td>0.5</td>
         <td>789</td>
         <td>66</td>
         <td>San Francisco</td>
      </tr>
      <tr>
         <td>Cedric Kelly</td>
         <td>Javascript Developer</td>
         <td>0.5</td>
         <td>45678</td>
         <td>22</td>
         <td>Edinburgh</td>
      </tr>
      <tr>
         <td>Jenna Elliott</td>
         <td>Financial Controller</td>
         <td>0.5</td>
         <td>892</td>
         <td>33</td>
         <td>Edinburgh</td>
      </tr>
      <tr>
         <td>Brielle Williamson</td>
         <td>Integration Specialist</td>
         <td>0.5</td>
         <td>15-501</td>
         <td>61</td>
         <td>New York</td>
      </tr>
      <tr>
         <td>Herrod Chandler</td>
         <td>Sales Assistant</td>
         <td>0.5</td>
         <td>751</td>
         <td>59</td>
         <td>San Francisco</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
 
new DataTable('#example', {
  layout: {
    topStart: {
      buttons: [
        {
          extend: 'excelHtml5',
          exportOptions: { columns: ':visible:not([data-dt-column*=","], .noExport)' }
        },
        {
          extend: 'colvis',
          columns: '[colspan=1]:not(.noColvis)'
        }
      ]
    }
  }
});
Output

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

Dismiss x
public
Bin info
anonymouspro
0viewers