i have an html table,where am trying to export the table as excel sheet on button click, my table code is like below:
<table id="basic-datatable" class="table dt-responsive nowrap">
<thead class="bg-dark">
<tr>
<th>#</th>
<th>Date</th>
<th> Party Name </th>
<th>Quotation Number</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<tr>
<td>somedata</td>
<td>somedate</td>
<td>somedata</td>
<td>somedata</td>
<td> <a href="<?" class="btn btn-info">view</a> </td>
<td> <a href="" class="btn btn-warning">edit</a> </td>
</tr>
</tbody>
</table>now i have done the following code to ezport the table as excel,
$(document).ready(function(){
$("#btnExport").click(function() {
let table = document.getElementsByTagName("table");
TableToExcel.convert(table[0], {
name: `export.xlsx`,
sheet: {
name: 'Sheet 1'
}
});
});
}); <button id="btnExport" class="btn btn-primary btn-icon-text btn-rounded"><i class="ti-clipboard btn-icon-prepend"></i>EXCEL EXPORT</button>
here the issue is the last tow columns edit and view are also coming in excel which i dont want, can anyone please tell me how to get rid of it, thanks in advance
You could assign each element you want to remove with a class, like no-export. Then whenever you want to export, create a clone and remove anything with the no-export class. This fiddle should give you a good idea of how to do this.