|导成Excel|

最新推荐文章于 2025-02-17 12:48:54 发布
iteye_13874
最新推荐文章于 2025-02-17 12:48:54 发布
阅读量98
点赞数
CC 4.0 BY-SA版权
分类专栏： js 文章标签： Excel Bean Struts JSP Apache
本文链接：https://blog.youkuaiyun.com/iteye_13874/article/details/81822083
js 专栏收录该内容
8 篇文章
订阅专栏
<%@ page language="java" pageEncoding="GBK"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic"%>
<%@ taglib uri="http://struts.apache.org/tags-tiles" prefix="tiles"%>
<%@ page import="java.util.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html:html lang="true">
<head>
<html:base />

<title>EmpParticular.jsp</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

<SCRIPT LANGUAGE="JavaScript">
<!--

function outDoc(){

var table=document.getElementById("custome");
row=table.rows.length;
column=table.rows(1).cells.length;

var excelapp=new ActiveXObject("Excel.Application");

excelapp.visible=true;
objBook=excelapp.Workbooks.Add();
var objSheet=objBook.ActiveSheet;
for(i=0;i<row;i++){
   for(j=0;j<column;j++){
   
   objSheet.Cells(i+1,j+1).value=table.rows(i).cells(j).innerHTML.replace("&nbsp;","");    
      
      
   }
    }

objBook.SaveAS("customerList.xls");
excelapp.UserControl=true;


}
//-->
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
function outDoc2(){

var table=document.getElementById("familyMember");
row=table.rows.length;
column=table.rows(1).cells.length;

var excelapp=new ActiveXObject("Excel.Application");

excelapp.visible=true;
objBook=excelapp.Workbooks.Add();
var objSheet=objBook.ActiveSheet;
for(i=0;i<row;i++){
   for(j=0;j<column;j++){
   
   objSheet.Cells(i+1,j+1).value=table.rows(i).cells(j).innerHTML.replace("&nbsp;","");    
      
  
   }
    }

objBook.SaveAS("customerList.xls");
excelapp.UserControl=true;


}
//-->
</SCRIPT>

     <style type="text/css">
/* CSS Document */

   body {
   font: normal 11px autoTrebuchet MS, Verdana, Arial, Helvetica, sans-serif;
   color: #000000;
   background: #E6EAE9;
   }

   a {
   color: #c75f3e;
   }

   #mytable {
   width: 700px;
   padding: 0;
   margin: 0;
   }

   caption {
   padding: 0 0 5px 0;
   width: 700px;
   font: italic 11px Trebuchet MS, Verdana, Arial, Helvetica, sans-serif;
   text-align: right;
   }

   th {
   font: bold 11px Trebuchet MS, Verdana, Arial, Helvetica, sans-serif;
   color: #000000;
   border-right: 1px solid #C2D9FE;
   border-bottom: 1px solid #C2D9FE;
   border-top: 1px solid #C2D9FE;
   letter-spacing: 2px;
   text-transform: uppercase;
   text-align: left;
   padding: 6px 6px 6px 12px;
   background: #CAE8EA url(images/bg_header.jpg) no-repeat;
   }
   td {
   border-right: 1px solid #C2D9FE;
   border-bottom: 1px solid #C2D9FE;
   background: #fff;
   font-size:11px;
   padding: 6px 6px 6px 12px;
   color: #000000;
   }
   td.alt {
   background: #F5FAFA;
   color: #797268;
   }
   th.spec {
   border-left: 1px solid #C2D9FE;
   border-top: 0;
   background: #fff url(images/bullet1.gif) no-repeat;
   font: bold 10px Trebuchet MS, Verdana, Arial, Helvetica, sans-serif;
   }
   th.specalt {
   border-left: 1px solid #C2D9FE;
   border-top: 0;
   background: #f5fafa url(images/bullet2.gif) no-repeat;
   font: bold 10px Trebuchet MS, Verdana, Arial, Helvetica, sans-serif;
   color: #797268;
   }
   /*---------for IE 5.x bug*/
   .btn2 {padding: 2 4 0 4;font-size:12px;height:23;background-color:#ece9d8;border-width:1;}

   /*新加的！！！*/
   input.in{
   font:bold;
   border: 3px double #ece9d8;

   background-color: #f5fafa;
   font-size: 12px;
   padding-top: 1px;
   cursor: hand;
   FILTER: progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr=#ffffff, EndColorStr=#C2D9FE);
   }
   input{
   font:bold;
   border: 2px double #ece9d8;
   background-color: #f5fafa;
   font-size: 12px;
   padding-top: 1px;
   cursor: hand;
   FILTER: progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr=#ffffff, EndColorStr=#C2D9FE);
   }
   input.but{
   font:bold;
   color:#797268;
   border: 3px double #ece9d8;
   height: 22px;
   width: 85px;
   background-color: #f5fafa;
   font-size: 12px;
   padding-top: 1px;
   cursor: hand;
   FILTER: progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr=#ffffff, EndColorStr=#C2D9FE);
   }
   .sel { font-size: 12px; width: 100px; position: relative; left: -2px; top: -2px;}
   .box { border:1 solid #BBBBBB; height: 19px; width: 99px; }
   .box2 { border:1 solid #FFFFFF; overflow: hidden; width: 97px; height: 17px; }
   .biaoti{
   FONT-SIZE: 12pt; FILTER: glow(color=000000,strength=2) dropshadow(color=#3333FF,offx=1, offy=1, positive=2); MARGIN: 0px; COLOR: #ffffff; HEIGHT: 20px; TEXT-DECORATION: none
   }
   input.btn2 {padding: 2 4 0 4;font-size:12px;height:23;background-color:#ece9d8;border-width:1;color:#797268;}
.style10 {
font-family: "仿宋_GB2312";
color: #000000;
font-size: 20px
}
.style5 {font-size: 36px}
</style>

</head>

<body>
<html:form action="user.do" method="post">
   <html:hidden property="action" value="out" />


   <table width="780" border="1" align="center" id="custome" >
    <tr align="center">
     <td height="30" colspan="4">

      <strong> <img src="/Curative/jsp/hr/images/bottom.jpg" width="780" height="30" align="absbottom"> </strong>

     </td>
    </tr>
  
    <logic:notEmpty name="LIST">
     <logic:iterate id="list" name="LIST" type="net.dbnet.curative.model.PersonBase">

      <tr align="center">
       <td height="30" colspan="4">
        <span class="style4">员工的 详细资料 </span>
       </td>
      </tr>
      <tr align="center" valign="middle">
       <td width="220" height="30">
        <span class="style4"> <strong> 科室编号 : </strong> </span>
       </td>
       <td width="180" height="30">
        <bean:write name="list" property="sectionNo" />
       </td>
       <td width="210" height="30" align="center">
        <span class="style4"> <STRONG> 最高学历: </STRONG> </span>
       </td>
       <td width="172" height="30">
        <bean:write name="list" property="highSchoolin" />
       </td>
      </tr>

      <tr align="center" valign="personName">
       <td height="30">
        <span class="style4"> <strong> 登陆用户名 : </strong> </span>
       </td>
       <td height="30">

        <bean:write name="list" property="loginName" />
       </td>
       <td height="30" align="center">
        <span class="style10 style11"> <SPAN class="style4"> <STRONG> 登陆密码 : </STRONG> </SPAN> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="loginPassword" />
       </td>
      </tr>


      <tr align="center" valign="personName">
       <td height="30">
        <span class="style4"> <strong> 姓 名 : </strong> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="personName" />
       </td>
       <td height="30" align="center">
        <span class="style10 style11"> <SPAN class="style4"> <STRONG> 学位 : </STRONG> </SPAN> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="degree" />
       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <span class="style4"> <strong> 曾用名 : </strong> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="anotherNo" />
       </td>
       <td height="30" align="center">
        <span class="style10 style11"> <SPAN class="style4"> <STRONG> 获学位时间: </STRONG> </SPAN> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="degreeDate" />
       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <span class="style4"><strong> 拼音码: </strong> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="spellNo" />

       </td>
       <td height="30" align="center">
        <span class="style4"> <strong> 毕业院校 : </strong> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="finishSchool" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <span class="style4"> <strong> 婚否 : </strong> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="marry" />

       </td>
       <td height="30" align="center">
        <SPAN class="style4"> <STRONG> 毕业时间 :   </STRONG> </SPAN>

       </td>
       <td height="30">
        <bean:write name="list" property="finishDate" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <span class="style4"> <STRONG> 性别 : </STRONG> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="personSex" />

       </td>
       <td height="30" align="center">
        <SPAN class="style4"> <STRONG> 授予单位 : </STRONG> </SPAN>
       </td>
       <td height="30">
        <bean:write name="list" property="schoolName" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <span class="style10 style11"> <SPAN class="style4"> <STRONG> 民族 : </STRONG> </SPAN> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="nation" />


       </td>
       <td height="30" align="center">
        <span class="style4"><STRONG> 专业技术职称 : </STRONG> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="titleNo" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
         <SPAN class="style4"> <STRONG> 出生地 : </STRONG> </SPAN> 
       </td>
       <td height="30">
        <bean:write name="list" property="birthPlace" />

       </td>
       <td height="30" align="center">
        <SPAN class="style4"><STRONG> 职务工资 : </STRONG> </SPAN>
       </td>
       <td height="30">
        <bean:write name="list" property="postWage" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <SPAN class="style4"> <STRONG> 现家庭住址 : </STRONG> </SPAN>
       </td>
       <td height="30">
        <bean:write name="list" property="familyAddress" />

       </td>
       <td height="30" align="center">
         <SPAN class="style4"> <STRONG> 现任行政职务 : </STRONG> </SPAN> 
       </td>
       <td height="30">
        <bean:write name="list" property="postNo" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
         <SPAN class="style4"> <STRONG> 出生日期 : </STRONG> </SPAN> 
       </td>
       <td height="30">
        <bean:write name="list" property="birthDate" />

       </td>
       <td height="30" align="center">
         <SPAN class="style4"> <STRONG> 从事本专业时间: </STRONG> </SPAN> 
       </td>
       <td height="30">
        <bean:write name="list" property="specialityDate" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <P align="center">
        <SPAN class="style4"> <STRONG> 身份证号 : </STRONG> </SPAN>
        </P>
       </td>
       <td height="30">
        <bean:write name="list" property="capacityNo" />

       </td>
       <td height="30" align="center">
        <span class="style4"> <STRONG> 聘任现职时间 : </STRONG> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="postDate" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
         <span class="style4"> <strong> 参加何种党派 : </strong> </span> 
       </td>
       <td height="30">
        <bean:write name="list" property="inParty" />

       </td>
       <td height="30" align="center">
        <span class="style4"> <strong>参加工作时间 :   </strong> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="inWorkDate" />

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <span class="style4"> <strong>参加党派时间 :   </strong> </span>
       </td>
       <td height="30">
        <bean:write name="list" property="portyDate" />

       </td>
       <td height="30" align="center">
        <span class="style4"> <strong> 来校工作时间 : </strong> </span>
       </td>
       <td height="30">
        <span class="style4"> <strong><bean:write name="list" property="inZsuDate" /></strong> </span>

       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30">
        <span class="style4"> <strong>   健康情况 : </strong> </span>
       </td>
       <td height="30">
        <span class="style4"> <strong><bean:write name="list" property="health" /></strong> </span>

       </td>
       <td height="30" align="center">
        <span class="style4"> <strong>备注 :</strong> </span>
       </td>
       <td height="30">

        <span class="style4"> <strong><bean:write name="list" property="remarks" /></strong> </span>
       </td>
      </tr>
      <tr align="center" valign="middle">
       <td height="30" colspan="2">
        <input type="submit" value="打印"/><%--onClick="outDoc()

       --%></td>
       <td height="30">
                                          <a href="../../../user.do?action=EmpParticular&personNo1=<bean:write name="list" property="personNo" />"> 修改</a>
       </td>
       <td height="30">
      
       <a href="../../../user.do?action=DeleteEmp&personNo1=<bean:write name="list" property="personNo" />">删除</a>

       </td>
      </tr>
      <tr align="center">

       <td height="30" colspan="4">

        <strong> <img src="/Curative/jsp/hr/images/kecheng_bg.jpg" width="780" height="30" align="absbottom"> </strong>

       </td>
      </tr>
     </logic:iterate>
    </logic:notEmpty>
    <!--<tr align="center">

      <td height="30" colspan="4">

       <strong> <img src="./jsp/hr/images/bottom_0.jpg" width="780" height="30" align="absbottom"> </strong>

      </td>
     </tr>-->
   </table>
  
  
</html:form>

</body>
</html:html>