Struts实时生成Excel文件下载

王朝java/jsp·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

我做的项目原来是先在服务器上生成一个excel文件,然后用jspsmartupload下载的,可是由于用jspsmartupload下载的excel文件由于编码问题会有损坏,而且服务器的压力也太大,所以改为在Action中生成excel文件,然后下载,方便多了。由于项目的原因,excel文件是实时生成的,对于jxl的使用,大家可以参考jxl相关的文章。

有什么问题可以和我联系。

MSN:whw_dream(AT)hotmail.com

代码如下:

test.jsp

<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>

<html:html>

<html:button property="button" onclick="printAll()">

DownLoad

</html:button>

</html:html>

<script language='javascript'>

function printAll(){ location.href="<%=request.getContextPath()%>/download.do"; }

</script>

DownloadAction.java

import org.apache.struts.action.*;

import javax.servlet.http.*;

import java.io.OutputStream;

import test.whw.upload.ExcelBean;

/**

* <p>Title:DownloadAction </p>

* <p>Description: QRRSMMS </p>

* <p>Copyright: Copyright (c) 2004 jiahansoft</p>

* <p>Company: jiahansoft</p>

* @author wanghw

* @version 1.0

*/

public class DownloadAction extends Action {

public ActionForward execute(ActionMapping mapping,

ActionForm form,

HttpServletRequest request,

HttpServletResponse response)

throws Exception {

try{

String fname = "test";//Excel文件名

OutputStream os = response.getOutputStream();//取得输出流

response.reset();//清空输出流

response.setHeader("Content-disposition", "attachment; filename=" + fname + ".xls");//设定输出文件头

response.setContentType("application/msexcel");//定义输出类型

ExcelBean eb = new ExcelBean();

eb.expordExcel(os);//调用生成excel文件bean

}catch(Exception e){

System.out.println(e);

}

return mapping.findForward("display");

}

}

ExcelBean.java

package test.whw.upload;

import java.io.*;

import jxl.*;

import jxl.write.*;

import jxl.format.*;

import java.util.*;

import java.awt.Color;

public class ExcelBean {

public ExcelBean(){}

public String expordExcel(OutputStream os)throws Exception{

jxl.write.WritableWorkbook wbook = Workbook.createWorkbook(os); //建立excel文件

String tmptitle = "测试文件"; //标题

jxl.write.WritableSheet wsheet = wbook.createSheet("第一页", 0); //sheet名称

//设置excel标题

jxl.write.WritableFont wfont = new jxl.write.WritableFont(

WritableFont.ARIAL, 16,

WritableFont.BOLD, false, jxl.format.UnderlineStyle.NO_UNDERLINE,

jxl.format.Colour.BLACK);

jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(

wfont);

jxl.write.Label wlabel1;

wlabel1 = new jxl.write.Label(5, 0, tmptitle, wcfFC);

wsheet.addCell(wlabel1);

wfont = new jxl.write.WritableFont(

WritableFont.ARIAL, 14,

WritableFont.BOLD, false, jxl.format.UnderlineStyle.NO_UNDERLINE,

jxl.format.Colour.BLACK);

wcfFC = new jxl.write.WritableCellFormat(

wfont);

jxl.write.Label wlabel;

wlabel = new jxl.write.Label(0, 0, "写入内容");

wsheet.addCell(wlabel); //

wbook.write(); //写入文件

wbook.close();

os.close();

return "success";

}

}

struts-config.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd">

<struts-config>

<action-mappings>

<action type="test.whw.upload.DownloadAction" path="/download">

<forward name="display" path="/display.jsp" />

</action>

</action-mappings>

</struts-config>

<!--display.jsp是成功的提示页面-->

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航