Advertisement
Guest User

Untitled

a guest
Nov 24th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ASP 2.57 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>Page Title</title>
  5. </head>
  6. <body>
  7.  
  8. <table id='datatable'>
  9. <tr>
  10. <td colspan='8' bgcolor='#87AFC6'>Title</td>
  11. </tr>
  12.  
  13. <%
  14. value = -1
  15. for i = 0 to 5
  16. value = value +2
  17. %>
  18.  
  19.  
  20. <tr class="noExl" id="cls<%=value%>">
  21. <td>
  22. <input type ="button" onclick="NoRisk('<%=value%>','<%=value+1%>')" value="<%=value%>">
  23. </td>
  24. <td>top</td>
  25. <td><%=value%></td>
  26. <td><%=value%></td>
  27. <td>row4</td>
  28. <td>row5</td>
  29. <td>row6</td>
  30. <td>row7</td>
  31. </tr>
  32.  
  33.  
  34.  
  35. <tr class="noExl" id="cls<%=value+1%>">
  36. <td><input type ="button" onclick="NoRisk('<%=value%>','<%=value+1%>')" value="<%=value+1%>"></td>
  37. <td>bottom</td>
  38. <td><%=value+1%></td>
  39. <td><%=value%></td>
  40. <td>row4</td>
  41. <td>row5</td>
  42. <td>row6</td>
  43. <td>row7</td>
  44. </tr>
  45.  
  46. <%Next%>
  47. <% response.write Date()%>
  48.  <iframe id="txtArea1" style="display:none"></iframe>
  49. </table>
  50.  
  51. <button type="button" onclick="ExportExcel()" value="0">Click Me!</button>
  52.  
  53. </body>
  54.  
  55. <script>
  56.  
  57. function NoRisk(n,m) {
  58.  
  59.     var element = document.getElementById('cls'+n);  
  60.     element.parentNode.removeChild(element);  
  61.     var element2 = document.getElementById('cls'+m);  
  62.     element2.parentNode.removeChild(element2);
  63.  
  64.     document.getElementById('cls'+m).style.display='none';
  65.     document.getElementById('cls'+n).style.display='none';
  66. }
  67.  
  68.  
  69. function ExportExcel(){
  70.  
  71.  
  72.  
  73. //copy innerHTML of YourTable to strCopy Variable.
  74.  
  75. var tab_text="<table border='2px'><tr>";
  76.                var textRange; var j=0;
  77.                tab = document.getElementById('datatable'); // id of table
  78.  
  79.                for(j = 0 ; j < tab.rows.length ; j++)
  80.                {    
  81.                      tab_text=tab_text+tab.rows[j].innerHTML+"</tr>";
  82.                      //tab_text=tab_text+"</tr>";
  83.                }
  84.  
  85.                tab_text=tab_text+"</table>";
  86.    
  87.  
  88.                var ua = window.navigator.userAgent;
  89.                var msie = ua.indexOf("MSIE ");
  90.  
  91.                if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
  92.                {
  93.                   txtArea1.document.open("txt/html","replace");
  94.                   txtArea1.document.write(tab_text);
  95.                   txtArea1.document.close();
  96.                   txtArea1.focus();
  97.                   sa=txtArea1.document.execCommand("SaveAs",true,"<% response.write Date()%>.xls");
  98.                }  
  99.                else //other browser not tested on IE 11
  100.                   sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));  
  101.                  return (sa);
  102.  
  103. }
  104. </script>
  105.  
  106. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement