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

最新推荐文章于 2023-07-04 19:22:35 发布

iteye_6050

最新推荐文章于 2023-07-04 19:22:35 发布

阅读量102

点赞数

分类专栏： JAVA相关文章标签： JSP Excel Java CSS JavaScript ViewUI

本文链接：https://blog.csdn.net/iteye_6050/article/details/81968056

版权

JAVA相关专栏收录该内容

10 篇文章 0 订阅

订阅专栏

<%@ 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 " οnclick="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>

iteye_6050

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
excel文件的页面（jsp）输出！

&lt;%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GBK"%&gt;&lt;%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%&gt;&lt;%@ taglib uri="http
复制链接

扫一扫

专栏目录