File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
<script src="https://code.jquery.com/jquery-3.1.0.min.js"></script>
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
<link href="https://nightly.datatables.net/select/css/select.dataTables.css?_=9a6592f8d74f8f520ff7b22342fa1183.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/select/js/dataTables.select.js?_=9a6592f8d74f8f520ff7b22342fa1183"></script>
​
    <link href="https://nightly.datatables.net/buttons/css/buttons.dataTables.css?_=a2f2f3edc9718bb6bdb965c105d22ce3.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/buttons/js/dataTables.buttons.js?_=a2f2f3edc9718bb6bdb965c105d22ce3"></script>
    <script src="https://nightly.datatables.net/buttons/js/buttons.html5.min.js"></script>
    <meta charset=utf-8 />
​
  </head>
  <body>
    <div class="container">
      <table id="example" class="display nowrap" width="100%">
        <thead>
          <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office</th>
            <th>Age</th>
            <th>Start date</th>
            <th>Salary</th>
          </tr>
        </thead>
​
        <tfoot>
          <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office</th>
            <th>Age</th>
            <th>Start date</th>
            <th>Salary</th>
          </tr>
        </tfoot>
​
        <tbody>
          <tr>
            <td><span>Tiger Nixon</span><select class="form-control" id="item_SOC_pFA_Result" name="item.SOC_pFA_Result" style="display:none"><option value=""></option>
          <option>Abnormal</option>
          <option>Abnormal 0</option>
          <option>BC</option>
              </select>
              </td>
            <td>System Architect</td>
            <td>Edinburgh</td>
            <td>61</td>
            <td>2011/04/25</td>
            <td>$3,120</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() {
  var table = $('#example').DataTable({
    dom: 'Blfrtip',
    select: true,
    columnDefs: [{
      targets: 0,
      render: function(data, type, row) {
        return type === "myExport"? $($(data)[0]).text() : data;
      }
    }],
    buttons: [
        {
          text: 'Select all',
          action: function() {
            table.rows().select();
          }
        },
        {
          extend: 'copyHtml5',
          exportOptions: {
            orthogonal: "myExport",
            modifier: {
              selected: true
            },
            columns: function(idx, data, node) {
              if(table.column(idx).visible() === true) {
                var isVisible = table.column(idx);
                //var txt = isVisible.find('span').text();
                return isVisible;
              }
            }
​
          }
        },
      {
        extend: "csvHtml5",
      exportOptions: {
        orthogonal: "myExport"
      }
      }
    ]
  });
});
Output 300px

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

Dismiss x
public
Bin info
anonymouspro
0viewers