jsp页面导出保存word或Excel几种方法及个人总结-os-操作系统-六狼论坛-IT论坛-计算机论坛

wengsibo 发表于 2013-2-7 10:01:40

jsp页面导出保存word或Excel几种方法及个人总结

以下是本人在做EXCEL/WORLD中在网上找的方法及个人总结：

方法1:
<%@ page contentType="application/msword; charset=GBK" %>//或者vnd.ms-word
<%@ page contentType="application/msexcel; charset=GBK" %> //或者vnd.ms-excel
通过设置可以使原来页面的内容在word或者excel中表现出来。

如果需要把word或者excel文档下载下来，只需在jsp页面上面加上如下代码：
<%
//线上浏览的方式：
response.setHeader("Content-disposition","inline; filename=test1.xls");
//下载的方式：
response.setHeader("Content-disposition","attachment; filename=test2.xls");
//以上这行设定传送到前端浏览器时的档名为test1.xls
//就是靠这一行，让前端浏览器以为接收到一个excel档
%>

方法2:
通过jxl等第三方来操作excel,这种网上资料丰富,
但这种又分两个方法：下面会介绍
1)在服务器端生成文件
String download_path = request.getSession().getServletContext().getRealPath("/") + "***.excel"; File file = new File(download_path);//生成个应的文件 WritableWorkbook book = Workbook.createWorkbook(file); WritableSheet sheet = book.createSheet("sheet", 0);//配置第一行的头 Label cardNoLabel = new Label(0, 0, "卡号"); Label cardTypeLabel = new Label(1, 0, "ICCID"); Label iccIdLabel = new Label(2, 0, "卡类型"); Label version = new Label(3, 0, "版本号"); Label m1NoLabel = new Label(4,0,"M1编号"); Label errorLabel = new Label(5, 0, "错误原因"); sheet.addCell(cardTypeLabel); sheet.addCell(cardNoLabel); sheet.addCell(iccIdLabel); sheet.addCell(errorLabel); sheet.addCell(version); sheet.addCell(m1NoLabel);//遍历生成相应数据for (int i = 0; i < size; i++) {String[] objects = cardList.get(i);String cardType = objects;String cardNo = objects.startsWith("0000") ? objects.substring(4) : objects;String iccId = objects;String m1No = objects;Object cardNoExists = existsQuery.setString(0, cardNo).uniqueResult();Object iccIdExists = iccIdQuery.setString(0, iccId).uniqueResult();if (cardNoExists != null) { sheet.addCell(new Label(0, i - successNum + 1, cardNo)); sheet.addCell(new Label(1, i - successNum + 1, iccId)); sheet.addCell(new Label(2, i - successNum + 1, cardType)); sheet.addCell(new Label(3, i - successNum + 1, apVersion)); sheet.addCell(new Label(4, i - successNum + 1, m1No)); sheet.addCell(new Label(5, i - successNum + 1, "卡号已存在"));} else if (iccIdExists != null) { sheet.addCell(new Label(0, i - successNum + 1, cardNo)); sheet.addCell(new Label(1, i - successNum + 1, iccId)); sheet.addCell(new Label(2, i - successNum + 1, cardType)); sheet.addCell(new Label(3, i - successNum + 1, apVersion)); sheet.addCell(new Label(4, i - successNum + 1, m1No)); sheet.addCell(new Label(5, i - successNum + 1, "iccid已存在"));} } book.write(); book.close();

2)服务端不生成文件
// 1.设定好response的相关属性： response.setContentType("application/vnd.ms-excel"); // URLEncoder.encode(qList.get("FUNCTION_NAME").toString(), "gbk") String downloadFileName = new String(qList.get("FUNCTION_NAME").toString().getBytes("GBK"), "ISO-8859-1"); response.setHeader("Content-Disposition", "attachment; filename=\"" + downloadFileName + ".xls" + "\""); // 2.取到response的OutputStream实例，并用这个实例化一个WritableWorkbook对象 OutputStream os = response.getOutputStream(); WritableWorkbook wwb = Workbook.createWorkbook(os); int ncout = resultList.size(); int maxnum = 50000; // 一次最多写入量 int times = (ncout + maxnum - 1) / maxnum; // 大循环 for (int t = 0; t < times; t++) {// 新建一张表WritableSheet wsheet = wwb.createSheet("members_" + (t + 1), t);// 设置表头Map<String, Object> tableNameMap = null;Label label;for (int i = 0; i < tableNameList.size(); i++) { tableNameMap = tableNameList.get(i); label = new Label(i, 0, tableNameMap.get("COLUMN_CHIN").toString()); wsheet.addCell(label);}// 读出数据,往表里加数据行int base = (t * maxnum);for (int i = 0; i < ncout; i++) { if (i == base + maxnum)break; Map<String, Object> resultMap = resultList.get(base + i); int size = 0; Iterator it = resultMap.entrySet().iterator(); while (it.hasNext()) {Map.Entry entry = (Map.Entry) it.next();String value;value = entry.getValue() == null ? "" : entry.getValue().toString();label = new Label(size, (i + 1), value);wsheet.addCell(label);size++;if (size == tableNameList.size()) break; }} }// 结束大循环 wwb.write(); wwb.close(); os.close(); // 把生成的excel数据输出到response的OutputStream response.flushBuffer();

方法3:
1.用word编辑一个模板，然后另存为HTML
2.在java类里面写velocity 语言代码
String path =getRequest().getSession().getServletContext().getRealPath("/");String filePath = path+"interview/management/exambatch/";VelocityEngine ve = getVelocityEngine(filePath);//文件模板的路径VelocityContext context = new VelocityContext();context.put("list", examineeGroupInfoList);//把数据加到入context中.这数据可以是list,可以是map,也可以是别的数据类型context.put("eximineeGroupInfoCount", eximineeGroupInfoCount);int size = examineeGroupInfoList.size();context.put("size", size);String srcFilename = "examineeGroupInfo_toWord.htm";//模板文件String destFilename = "examineeGroupInfo_toWord.doc";//通过模板,生成的doc文件名Template template;try {Velocity.init();template = ve.getTemplate(srcFilename, "GBK");BufferedWriter writer =new BufferedWriter(new FileWriter(filePath+destFilename));//把生成的文件写到路径中去template.merge(context, writer);writer.flush();writer.close();System.out.println("finish!!");} catch (ResourceNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (ParseErrorException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}

3.在模板上编辑context中的数据,以下内容主要是velocity语言的for及el表达式来取值的
<%@ page contentType="application/msword; charset=gb2312" %><%@include file="/sys/common/taglibs.jsp"%><html xmlns:v="urn:schemas-microsoft-com:vml"xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:w="urn:schemas-microsoft-com:office:word"xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv="Content-Type" content="application/msword; charset=gb2312" /><meta name=ProgId content=Word.Document><meta name=Generator content="Microsoft Word 11"><meta name=Originator content="Microsoft Word 11"><link rel=File-List href="examineeGroupInfo_toWord.files/filelist.xml"><title>考生分组情况</title><style></style></head><body lang=ZH-CN style='tab-interval:21.0pt;text-justify-trim:punctuation'><div class=Section1 style='layout-grid:15.6pt'><spanstyle='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>考生分组情况<o:p>&nbsp;</o:p><div align=center>#set( $task =1 )<table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 width=660 style='width:495.0pt;margin-left:-39.6pt;border-collapse:collapse;border:none; mso-border-alt:solid windowtext .5pt;mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-border-insideh:.5pt solid windowtext;mso-border-insidev:.5pt solid windowtext'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:25.1pt'><td width=180 valign=top style='width:135.0pt;border:solid windowtext 1.0pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>批次名称：</td><td width=480 colspan=3 valign=top style='width:360.0pt;border:solid windowtext 1.0pt;border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'> #set( $task =1 )#foreach ($list2 in $list ) #foreach ($list3 in $list2 ) #if($task==1)$list3.BATCH_NAME #end#set( $task =$task+1 )#end#end</td> </tr> <tr style='mso-yfti-irow:1;height:25.1pt'><td width=180 valign=top style='width:135.0pt;border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>面试开始时间：</td><td width=480 colspan=3 valign=top style='width:360.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'> #set( $task =1 )#foreach ($list2 in $list ) #foreach ($list3 in $list2 ) #if($task==1)#if ($list3.START_TIME ) $list3.START_TIME #end#end#set( $task =$task+1 )#end #end</td> </tr> <tr style='mso-yfti-irow:2;height:25.1pt'><td width=180 valign=top style='width:135.0pt;border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>批次说明：</td><td width=480 colspan=3 valign=top style='width:360.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'>#set( $task =1 )#foreach ($list2 in $list ) #foreach ($list3 in $list2 ) #if($task==1)#if ($list3.REMARK) $list3.REMARK#end#end#set( $task =$task+1 )#end#end</td> </tr> <tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes;height:25.15pt'><td width=180 valign=top style='width:135.0pt;border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.15pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>小组数量：</td><td width=168 valign=top style='width:126.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.15pt'>$size</td><td width=84 valign=top style='width:63.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.15pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>总人数：</td><td width=228 valign=top style='width:171.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.15pt'>$eximineeGroupInfoCount</td> </tr></table></div><o:p>&nbsp;</o:p><div align=center> #foreach ($list2 in $list ) <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 width=660 style='width:495.0pt;margin-left:-39.6pt;border-collapse:collapse;border:none; mso-border-alt:solid windowtext .5pt;mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-border-insideh:.5pt solid windowtext;mso-border-insidev:.5pt solid windowtext'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:25.1pt'><td width=120 valign=top style='width:90.0pt;border:solid windowtext 1.0pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>小组名称：</td><td width=540 colspan=4 valign=top style='width:405.0pt;border:solid windowtext 1.0pt;border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'>#foreach ($list3 in $list2 ) ${list3.GROUP_NAME}#end </td> </tr> <tr style='mso-yfti-irow:1;height:25.1pt'><td width=120 valign=top style='width:90.0pt;border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>姓名</td><td width=156 valign=top style='width:117.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>报考单位部门</td><td width=156 valign=top style='width:117.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>报考单位部门代码</td><td width=120 valign=top style='width:90.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>报考职务</td><td width=108 valign=top style='width:81.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>报考职务代码</td> </tr> <%--==========================内循坏=============================--%> #set($popleNumber = 0) #foreach ($list3 in $list2 )<tr style='mso-yfti-irow:2;height:25.1pt'><td width=120 valign=top style='width:90.0pt;border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'><spanstyle='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>${list3.EXAMINEE_NAME}</td><td width=156 valign=top style='width:117.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'>${list3.SIGNCOMPANY}</td><td width=156 valign=top style='width:117.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'>${list3.SIGNCOMPANY_CODE}</td><td width=120 valign=top style='width:90.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'>${list3.SIGNPOSITION}</td><td width=108 valign=top style='width:81.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.1pt'>${list3.SIGNPOSITION_CODE}</td> </tr> #set($popleNumber = $popleNumber+1) #end <tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes;height:25.15pt'><td width=120 valign=top style='width:90.0pt;border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.15pt'><spanstyle='font-size:10.0pt;font-family:宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:Arial;color:#555555'>人数：</td><td width=540 colspan=4 valign=top style='width:405.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.15pt'>$popleNumber</td> </tr></table> #end</div><o:p>&nbsp;</o:p><o:p>&nbsp;</o:p></div></body></html>

如有不对的地方，请指出。

页: [1]

六狼论坛's Archiver

jsp页面导出保存word或Excel几种方法及个人总结