项目中导出Excel报表

最新推荐文章于 2024-02-26 16:19:18 发布

Jefry2008

最新推荐文章于 2024-02-26 16:19:18 发布

阅读量168

点赞数

分类专栏： Java 文章标签： Excel Servlet Apache Tomcat J#

本文链接：https://blog.csdn.net/Jefry2008/article/details/83800622

版权

Java 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

2010年12月22日，冬至。今天终于把南美话单分拣报表做完，主要实现将报表数据用EXCEL导出。于是自己写了一个小例子与大家分享。
[b] 1、准备Apache提供的开源jar包poi-3.0.1-FINAL-20070705.jar，我将把它上载上来，供大家方便使用。[/b]
[b] 2、编写导出Excel类[/b]

 package com.zte.excel;

import java.io.IOException;
import java.io.OutputStream;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ExcelReport {
	public void export(HttpServletResponse response) throws IOException {
		response.setHeader("Content-disposition", "attachment;filename=test.xls");

		OutputStream out = response.getOutputStream();
	    HSSFWorkbook wb = new HSSFWorkbook();

	    HSSFSheet sheet = wb.createSheet("sheet1");

	    //模拟数据
	    String[] head = {"第一列","第二列","第三列","第四列"};
	    Object[][] body = {{1,2,3,4},{5,6,7,8},{9,10,11,12},{13,14,15,16},{"我","爱","你","!"}};

	    //文件头
	    HSSFRow rowHead = sheet.createRow(0);


	    for(int i = 0; i< head.length; i++) {
	    	HSSFCell cell = rowHead.createCell((short)i);
	    	cell.setCellValue(new HSSFRichTextString(head[i]));
	    }
	    //文件体
	    for(int j = 0; j < body.length ; j ++) {
	    	for(int k = 0 ; k < body[j].length ; k++ ) {
	    		HSSFRow rowBody = sheet.createRow(j + 1);
	    		HSSFCell cell = rowBody.createCell((short)k);
		    	cell.setCellValue(new HSSFRichTextString(String.valueOf((body[j][k]))));
	    	}
	    }

	    wb.write(out);


	}
}

[b]3、编写Servlet[/b]

 package com.zte.excel;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class for Servlet: ExcelControl
 *
 */
 public class ExcelControl extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		 ExcelReport excelReport = new ExcelReport();
		 excelReport.export(response);
	}  	


	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	    doGet(request, response);
	}   	  	    
}

[b]4、编写index.htm页面[/b]

<html>
<head>
   <script type="text/javascript">
     function exportExcel(){
       window.location="ExcelControl"    
     }

   </script>
</head>
    <body>
      <center>
       <div style="border:1px red solid;width:250;height: 100;background-color:yellow;">
       <br>
       <h3><---Excel表导出测试---></h3>
       <input type="button" value="导出EXCEL" onclick="exportExcel()" />
    </div>
    </center>
    </body>
</html>

[b]5、启动Tomcat,并访问页面index.html页面[/b]
OK，成功

Jefry2008

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
项目中导出Excel报表

2010年12月22日，冬至。今天终于把南美话单分拣报表做完，主要实现将报表数据用EXCEL导出。于是自己写了一个小例子与大家分享。 [b] 1、准备Apache提供的开源jar包poi-3.0.1-FINAL-20070705.jar，我将把它上载上来，供大家方便使用。[/b] [b] 2、编写导出Excel类[/b] [code="java"] package co...
复制链接

扫一扫