excel文件的页面（jsp）输出！

pacer123

浏览: 90805 次
性别:
来自: 西安

最近访客更多访客>>

0101wangling

rjzou2006

zq216991

娃儿001

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

JAVA相关

JSP Excel Java CSS JavaScript

<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GBK"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://www.ecside.org" prefix="ec"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.SimpleDateFormat"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt_rt" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@page import="java.util.Calendar,java.util.*,
java.io.*,jxl.*,javax.servlet.ServletContext"
%>
<html >
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=MS950">
<link rel="stylesheet" Content-type="text/css" href="../../css/webber.css">
<script language="JavaScript" src="lib/prototype/prototype.js"></script>
<%
String fileName = (String) request.getAttribute("fileName");
%>
<script language="JavaScript">
function exportExcel()
{
var url = "download.jsp?fileName=" + "<%=fileName%>";
window.location.href(url);
}

</script>

<title>各功能访问情况比例统计</title>

<jsp:include page="../common_head.jsp" flush="true" />

</head>

<body >
<table align=center class=listFrame cellspacing=1 cellpadding=0
width="85%">
<tbody>
  <tr align="right">
   <td ><INPUT
    type="button" class="funButton" value=" 导出Excel " onclick="exportExcel()">   </td>
  </tr>
  <tr>
   <td   colspan=21
    style="font-size: 16px; line-height: 30px; BACKGROUND-COLOR: #bddbf7"><b><c:out
    value="${title}" /></b></td>
  </tr>
</tbody>
</table>
<div id="div1" style="scroll:auto;overflow:auto;width:100%;letter-spacing:0.2em;height:450px;top:100px;left:50px">
<table align=center class=listFrame cellspacing=1 cellpadding=0 width="85%">
     <%
     fileName = (String) request.getAttribute("fileName");
     String filePath = application
        .getRealPath("/report/"
        + fileName);
     FileInputStream finput = new FileInputStream(filePath);
     Workbook wbook;
     wbook = Workbook.getWorkbook(finput);
     Sheet wsheet = (Sheet) wbook.getSheet(0);
     finput.close();
     Cell[] rowcell = null;
     Cell cell = null;
     short i = 0;
     short y = 0;
     for (i = 0; i < wsheet.getRows(); i++) {
       out.println("<tr>");
       rowcell = wsheet.getRow(i);

       for (y = 0; y < rowcell.length; y++) {
        cell = rowcell[y];
        out.print("<td class=listContent>");
        cell.getCellFormat().getFont().getBoldWeight();
        //字体宽度
        int bw = cell.getCellFormat().getFont().getBoldWeight();

        if (null != cell) {
         if(bw == 700)
            {
          out.print("<b>"+cell.getContents().replace(" ","  ")+"</b>");
            }else{
             out.print(cell.getContents().replace(" ","  "));
            }

        }

        out.println("</td>");
       }
       out.println("</tr>");
     }
     %>
</table>
</div>
</body>
</html>

分享到：

公共的文件下载页面实现！ | mysql的自动备份

2010-12-02 14:26
浏览 966
评论(0)
分类:Web前端
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论