[FIXED] how to skip particular columns while exporting html table as excel using javascript

Issue

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

Solution

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.

https://jsfiddle.net/9wr2sc8g/1/

Answered By - Arkin Solomon

Answer Checked By - Marilyn (PHPFixing Volunteer)