datatables - How to hide Full jQuery data table but while export data to excel it should show all data

Question

 $('#divTable').hide();

 <div id="divTable">
     <table id="tbl_memberDetailReport" runat="server" class="odd_line" style="width: 100%;" 
     cellpadding="2" cellspacing="2"></table>                                    
     <table id="tbl_ExportToExcelData"></table>                                                                                                  
 </div>  

I have given a div class outside of table and later I hide it using $('#divTable').hide(); but the problem is I want same data while exporting it to excel

question from:https://stackoverflow.com/questions/65931757/how-to-hide-full-jquery-data-table-but-while-export-data-to-excel-it-should-show

Answer 1

Waitting for answers