DataTables Buttons

by darkkyoun

HTML

<script src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.9/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.0.3/css/buttons.dataTables.min.css">
<script src="https://cdn.datatables.net/buttons/1.0.3/js/dataTables.buttons.min.js"></script>
<script src="https://rawgit.com/simonbengtsson/Buttons/master/js/buttons.html5.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/css/all.min.css">
<table id="example" class="display" cellspacing="0" 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>Tiger Nöxon</td>
            <td>System Architect</td>
            <td>Edinbårgh</td>
            <td>61</td>
            <td>2011/04/25</td>
            <td>$320,800</td>
        </tr>
        <tr>
            <td>Garrett Winters</td>
            <td>Accoåntant</td>
            <td>Tokyo</td>
            <td>63</td>
            <td>2011/07/25</td>
            <td>$170,750</td>
        </tr>
        <tr>
            <td>Ashton Cox</td>
            <td>Jånior Technical Aåthor</td>
            <td>San Francisco</td>
            <td>66</td>
            <td>2009/01/12</td>
            <td>$86,000</td>
        </tr>
        <tr>
            <td>Cedric Kelly</td>
            <td>Senior Javascript Developer</td>
            <td>Edinbårgh</td>
            <td>22</td>
            <td>2012/03/29</td>
            <td>$433,060</td>
        </tr>
        <tr>
           ...

CSS

div.dt-buttons {
    float: right;
}
.dataTables_wrapper .dataTables_filter {
    float: left;
}

JavaScript

$(document).ready(function () {
    $('#example').DataTable({
        searching: true,
        ordering: true,
        select: true,
        dom: 'fBrtip<"clear">l',
        buttons: [
        {
            extend: 'csv',
            fieldSeparator: ';',
            title: 'data',
            text: '<i class="fas fa-file-csv" aria-hidden="true"> csv</i>'
        },
        {
            extend: 'excel',
            fieldSeparator: ';',
            title: 'data',
            text : '<i class="fas fa-file-excel" aria-hidden="true"> Excel</i>'
        },
        
        
        ]
    });
});