将页面数据导出到excel文件

ablya · 发表于 2013-2-7 21:10:13

http://anqli.iteye.com/blog/394078

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>EB页面导出为EXCEL文档的方法</title> <script type="text/javascript">  </script> </head> <body> <div id="tableExcel"> sgsdhdfjdghjfghkfhjkghjgkhjkf <table id="test" width="100%" border="1" cellspacing="0" cellpadding="0"> <tr> <td colspan="5" align="center">WEB页面导出为EXCEL文档的方法</td> </tr> <tr> <td>列标题1</td> <td>列标题2</td> <td>列标题3</td> <td>列标题4</td> <td>列标题5</td> </tr> <tr> <td>aaa</td> <td>bbb</td> <td>ccc</td> <td>ddd</td> <td>eee</td> </tr> <tr> <td>AAA</td> <td>BBB</td> <td>CCC</td> <td>DDD</td> <td>EEE</td> </tr> <tr> <td>FFF</td> <td>GGG</td> <td>HHH</td> <td>III</td> <td>JJJ</td> </tr> <tr> <td>aaa</td> <td>bbb</td> <td>ccc</td> <td>ddd</td> <td>eee</td> </tr> <tr> <td>AAA</td> <td>BBB</td> <td>CCC</td> <td>DDD</td> <td>EEE</td> </tr> <tr> <td colspan="5">FFFGGGHHHIIIJJJ</td> </tr> <tr> <td>aaa</td> <td>bbb</td> <td>ccc</td> <td>ddd</td> <td>eee</td> </tr> <tr> <td>AAA</td> <td>BBB</td> <td rowspan="4">CCCHHHcccccc</td> <td>DDD</td> <td>EEE</td> </tr> <tr> <td>FFF</td> <td>GGG</td> <td>III</td> <td>JJJ</td> </tr> <tr> <td>aaa</td> <td>bbb</td> <td>ddd</td> <td>eee</td> </tr> <tr> <td>aaa</td> <td>bbb</td> <td>ddd</td> <td>eee</td> </tr> <tr> <td>AAA</td> <td>BBB</td> <td>CCC</td> <td>DDD</td> <td>EEE</td> </tr> <tr> <td>FFF</td> <td>GGG</td> <td>HHH</td> <td>III</td> <td>JJJ</td> </tr> </table> </div> <input type="button" value="另存为 Excel" > <input name="innerHTML" value="innerHTML" type="button" > <input name="outerHTML" value="outerHTML" type="button" > <input name="innerText" value="innerText" type="button" > <input name="outerText" value="outerText" type="button" > </body> </html>

		自动登录	找回密码
密码			立即注册

将页面数据导出到excel文件

浏览过的版块