无法使用jquery和php $ _GET导出html表

Question

my downloaded table only prints headers and does not display any content. iam following the tutorial from here:http://webslesson.blogspot.in/2016/02/export-mysql-data-to-excel-in-php-php-tutorial.html

THE FOLLOWING PLUGINS i have tried which fails to render my huge data 1.clarketm(merges rows) 2.(tried but unable to render huge dat)https://github.com/kayalshri/tableExport.jquery.plugin

my HTML DOM IS (index.php)

<div id="allTables">
    <table border="2" width="100%">
                <tr>
                    <th width="30%">Name</th>
                    <th width="20%">Activity on Code Project (%)</th>
                    <th width="10%">Activity on C# Corner (%)</th>
                    <th width="10%">Activity on Asp Forum (%)</th>
                </tr>
                <tr>
                    <td>Sibeesh</td>
                    <td>100</td>
                    <td>98</td>
                    <td>80</td>
                </tr>
                <tr>
                    <td>Ajay</td>
                    <td>90</td>
                    <td>0</td>
                    <td>50</td>
                </tr>
                    </table>
</div>
<p id="exportexcel">EXport to Excel</p>

<script>
 $(document).ready(function () {
    $('#exportexcel').click(function(){
          var excel_data = $('#allTables').html();
          console.log(excel_data);
          var page = "excel.php?data="+excel_data;
          console.log(page);
          window.location = page; // here iam sending data to excel.php through get method
 });
</script>

my excel.php file is

<?php
  header('Content-Type: application/vnd.ms-excel');
  header('Content-disposition: attachment; filename='.rand().'.xls');
  echo $_GET["data"];
?>

--please help me what iam doing wrong thanks in advance

Answer 1

Activity on C# Corner (%) - "#" in this line is causing the problem. encoding this will resolve the issue in above code.

But its better to use POST as suggested.