jsp网页中显示的数据导入到excel中



jsp网页中显示的数据导入到excel中的方法介绍。

<%@ page language=”java” import=”java.util.*” pageEncoding=”utf-8″%>

<script type=”text/javascript”>

function saveCode(obj) {

          var winname = window.open(”, ‘_blank’, ‘top=10000′);

          var strHTML = document.getElementById(obj).innerHTML;

          winname.document.open(‘text/html’, ‘replace’);

          winname.document.writeln(strHTML);

          winname.document.execCommand(‘saveas’,”,’excel.xls’);

          winname.close();

}

</script>

<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”>

<html>

  <head>   

    <title>My JSP ‘test.jsp’ starting page</title>

  </head> 

  <body>  

<div id=”tableExcel”> 

<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 colspan=”5″>FFFGGGHHHIIIJJJ</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” onclick=”saveCode(‘tableExcel’)”>

  </body>

</html>