Java导出Excel总结.doc

写Excel的方法类为JxlExcelWriter：import jxl.Workbook;import jxl.format.UnderlineStyle;import jxl.format.Colour;import jxl.write.*;import jxl.write.biff.RowsExceededException;import java.io.IOException;import java.io.OutputStream;import java.util.Date;import java.util.List;public class JxlExcelWriter public void writeExcel(OutputStream out, List datas, String title) if (datas = null) throw new IllegalArgumentException(写excel流需要List参数!); try WritableWorkbook workbook = Workbook.createWorkbook(out); WritableSheet ws = workbook.createSheet(sheet1, 0); int rowNum = 1; /要写的行 if (title != null) putDescription(ws); putTitle(ws, 1, title);/压入标题 Object cells = (Object) datas.get(0); putRow(ws, rowNum, cells); /压一行到sheet int dataNum = 2; /要写的数据行 for(int i = 1; i datas.size(); i+, dataNum+) /把数据写进sheet Object cells = (Object) datas.get(i); putDatas(ws, dataNum, cells); /压入一行数据到sheet putTime(ws); /压入时间 workbook.write(); workbook.close(); /一定要关闭, 否则没有保存Excel catch (RowsExceededException e) System.out.println(jxl write RowsExceededException: + e.getMessage(); catch (WriteException e) System.out.println(jxl write WriteException: + e.getMessage(); catch (IOException e) System.out.println(jxl write file i/o exception!, cause by: + e.getMessage(); private void putTime(WritableSheet ws) throws RowsExceededException, WriteException DateFormat df = new DateFormat(yyyy-MM-dd hh:mm:ss); WritableCellFormat wcfDF = new WritableCellFormat(df); DateTime labelDT = new DateTime(4, 10, new Date(), wcfDF); ws.addCell(labelDT); private void putDescription(WritableSheet ws) throws RowsExceededException,WriteException WritableFont wfc = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD,false, UnderlineStyle.NO_UNDERLINE, Colour.BLUE); WritableCellFormat wcfFC = new WritableCellFormat(wfc); String description = 合计与盘盈的数量(条)不区分(联通、网通)、是否上市; String unit = 单位：元; Label descriptions = new Label(2, 0, + description, wcfFC); ws.addCell(descriptions); Label units = new Label(4, 0, + unit); ws.addCell(units); private void putTitle(WritableSheet ws, int rowNum, Object titles) throwsRowsExceededException, WriteException for (int j = 1; j titles.length + 1; j+) /写一行 Label title = new Label(j, rowNum, + titlesj-1); ws.addCell(title); private void putRow(WritableSheet ws, int rowNum, Object cells) throwsRowsExceededException, WriteException for (int j = 1; j cells.length + 1; j+) /写一行 Label cellRows = new Label(0, j, + cellsj-1); / Label(0, j, + String) 表示列不变行变，也就是说在第0列有n行数据 ws.addCell(cellRows); private void putDatas(WritableSheet ws, int dataNum, Object cells) throwsRowsExceededException, WriteException for (int j = 1; j cells.length + 1; j+) /写一行 Label cellRows = new Label(j, dataNum, + cellsj-1); ws.addCell(cellRows); 导出Excel的类为ExportLtTotalExcel：import com.sino.ams.bean.JxlExcelWriter;import javax.servlet.http.HttpServletResponse;import javax.servlet.ServletOutputStream;import java.util.List;import java.util.ArrayList;import java.util.StringTokenizer;import java.io.*;import java.sql.Connection;public class ExportLtTotalExcel protected Connection conn = null; protected HttpServletResponse res = null; protected String fileName = 固定资产-清查总体情况表; /保存Excel时的名字 public ExportLtTotalExcel(Connection conn, HttpServletResponse res) this.conn = conn; this.res = res; public ExportLtTotalExcel(HttpServletResponse res) this.res = res; public void writeExcel(String normal, String free, String damaged, String loss,String total, String win) List datas = new ArrayList(); String rows = 集团总部, 在用, 闲置, 损毁, 盘亏, 总部资产合计, 总部资产盘盈; String struct = 原值, 累计折旧（或摊销）, 净值, 数量(条); datas.add(rows); datas.add(normal); datas.add(free); datas.add(damaged); datas.add(loss); datas.add(total); datas.add(win); try res.setContentType(application/vnd.ms-excel); if (!fileName.equals() String header = attachment; filename= + new String(fileName+ .xls).getBytes(), iso8859-1); res.setHeader(Content-Disposition, header); ServletOutputStream out = res.getOutputStream(); JxlExcelWriter jxlExcelWriter = new JxlExcelWriter(); jxlExcelWriter.writeExcel(out, datas, struct); out.close(); res.flushBuffer(); catch (IOException e) e.printStackTrace(); 负责跟Web接口的Servlet类为LtAssetsTotalDataServlet：import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpServlet;public class LtAssetsTotalDataServlet extends HttpServlet public void performTask(HttpServletRequest req, HttpServletResponse res) throwsServletException, IOException String forwardURL = ; Message message = SessionUtil.getMessage(req);Connection conn = null; try String action = dto.getAct(); conn = getDBConnection(req); if (action.equals(AssetsActionConstant.EXPORT_ACTION) /下面String数组中的值都是从Model里查出来的String型的字符串值 String normal = normalCostS, normalDeprnReserveS, normalNetAssetValueS, normalTotalS; String free = freeCostS, freeDeprnReserveS, freeNetAssetValueS, freetotalS; String damaged = damagedCostS, damagedDeprnReserveS, damagedNetAssetValueS, damagedTotalS; String loss = lossCostS, lossDeprnReserveS, lossNetAssetValueS, lossTotalS; String tota