Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>Page Title</title>
- </head>
- <body>
- <table id='datatable'>
- <tr>
- <td colspan='8' bgcolor='#87AFC6'>Title</td>
- </tr>
- <%
- value = -1
- for i = 0 to 5
- value = value +2
- %>
- <tr class="noExl" id="cls<%=value%>">
- <td>
- <input type ="button" onclick="NoRisk('<%=value%>','<%=value+1%>')" value="<%=value%>">
- </td>
- <td>top</td>
- <td><%=value%></td>
- <td><%=value%></td>
- <td>row4</td>
- <td>row5</td>
- <td>row6</td>
- <td>row7</td>
- </tr>
- <tr class="noExl" id="cls<%=value+1%>">
- <td><input type ="button" onclick="NoRisk('<%=value%>','<%=value+1%>')" value="<%=value+1%>"></td>
- <td>bottom</td>
- <td><%=value+1%></td>
- <td><%=value%></td>
- <td>row4</td>
- <td>row5</td>
- <td>row6</td>
- <td>row7</td>
- </tr>
- <%Next%>
- <% response.write Date()%>
- <iframe id="txtArea1" style="display:none"></iframe>
- </table>
- <button type="button" onclick="ExportExcel()" value="0">Click Me!</button>
- </body>
- <script>
- function NoRisk(n,m) {
- var element = document.getElementById('cls'+n);
- element.parentNode.removeChild(element);
- var element2 = document.getElementById('cls'+m);
- element2.parentNode.removeChild(element2);
- document.getElementById('cls'+m).style.display='none';
- document.getElementById('cls'+n).style.display='none';
- }
- function ExportExcel(){
- //copy innerHTML of YourTable to strCopy Variable.
- var tab_text="<table border='2px'><tr>";
- var textRange; var j=0;
- tab = document.getElementById('datatable'); // id of table
- for(j = 0 ; j < tab.rows.length ; j++)
- {
- tab_text=tab_text+tab.rows[j].innerHTML+"</tr>";
- //tab_text=tab_text+"</tr>";
- }
- tab_text=tab_text+"</table>";
- var ua = window.navigator.userAgent;
- var msie = ua.indexOf("MSIE ");
- if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer
- {
- txtArea1.document.open("txt/html","replace");
- txtArea1.document.write(tab_text);
- txtArea1.document.close();
- txtArea1.focus();
- sa=txtArea1.document.execCommand("SaveAs",true,"<% response.write Date()%>.xls");
- }
- else //other browser not tested on IE 11
- sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));
- return (sa);
- }
- </script>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement