java excel导出功能_Java的Excel导出功能

以前用到的：

ExcelServlet

ExcelServlet

*.excel.ExcelServlet

ExcelServlet

*.xls

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;

public class ExcelServlet extends HttpServlet {

private final Logger log = Log4jUtil.getLogger(ExcelServlet.class);

public void init() throws ServletException {

}

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("application/vnd.ms-excel");

RequestPage page = new RequestPage(request, response, request.getSession());

ExcelOperator operator = null;

try {

operator = getOperator(request.getServletPath());

if (operator != null) {

operator.execute(page);

}

} catch (Exception ex) {

log.debug("导出excel出错：" + ex.toString());

ex.printStackTrace();

}

}

/**

* 根据不同的请求path获取不同的导出excel操作

*

* @param path

* @return

*/

public ExcelOperator getOperator(String path) {

return new ReportExcelExport();

}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

doGet(request, response);

}

public void destroy() {

}

}

import java.io.IOException;

import jxl.write.WriteException;

public abstract class ExcelOperator {

jxl.write.WritableWorkbook excel = null;

int fieldCount = 0;

public RequestPage page;

public void execute(RequestPage page) throws WriteException,

IndexOutOfBoundsException, IOException {

this.page = page;

excel = jxl.Workbook.createWorkbook(this.page.getResponse()

.getOutputStream());

excel.createSheet("sheet1", 0);

setTitle(getTitle());

writeContent(getContent());

write();

}

private void setTitle(String[] fields) throws IndexOutOfBoundsException,

WriteException {

this.fieldCount = fields.length;

for (int i = 0; i < fields.length; i++) {

excel.getSheet(0).addCell(new jxl.write.Label(i, 0, fields[i]));

}

}

private void writeContent(java.util.ArrayList cells)

throws IndexOutOfBoundsException, WriteException {

if (cells == null)

return;

for (int i = 1; i <= cells.size(); i++) {

Object obj = cells.get(i - 1);

for (int j = 0; j < fieldCount; j++) {

excel.getSheet(0).addCell(

new jxl.write.Label(j, i, getValue(obj, j)));

}

}

}

public abstract String getValue(Object obj, int index);

public abstract String[] getTitle();

public abstract java.util.ArrayList getContent();

private void write() throws IOException, WriteException, IOException {

excel.write();

excel.close();

}

}

import java.util.ArrayList;

import java.util.HashMap;

public class ReportExcelExport extends ExcelOperator {

@Override

public ArrayList getContent() {

}

/**

* 报表表头

*/

@Override

public String[] getTitle() {

return new String[] { "责任人ID","责任人","责任人角色","年份" };

}

/**

* 单元格的值

*/

@Override

public String getValue(Object obj, int index) {

switch (index) {

case 0:

return values.getUserId();

default:

return "";

}

}

}

ref:

if (request.getHeader("User-Agent").indexOf("MSIE 5.5") != -1) {

response.setHeader("Content-Disposition", "filename=" + fileName);

} else {

response.addHeader("Content-Disposition", "attachment;filename=" + fileName);

}

response.setCharacterEncoding("GBK");

//response.setContentType("text/html;charset=GBK");

ServletOutputStream stream = null;

BufferedInputStream buf = null;

FileInputStream fis = null;

try {

stream = response.getOutputStream();

fis = new FileInputStream(file);

buf = new BufferedInputStream(fis);

byte[] readBytes = new byte[4096];

int len = 0;

while ((len = buf.read(readBytes)) != -1) {

stream.write(readBytes, 0, len);

}

stream.flush();

response.setStatus(HttpServletResponse.SC_OK);

response.flushBuffer();

} catch (Exception ex) {

logger.info(ex.toString());

} finally {

if (stream != null) {

try {

stream.close();

} catch (IOException e) {

logger.info(e.toString());

e.printStackTrace();

}

}

if (buf != null) {

try {

buf.close();

} catch (IOException e) {

logger.info(e.toString());

e.printStackTrace();

}

}

if (fis != null) {

try {

fis.close();

} catch (IOException e) {

logger.info(e.toString());

e.printStackTrace();

}

}

}