学习excel和word格式导出功能

 

导出为word格式类似如下：
	// 创建word文档,并设置纸张的大小   
		Document document = new Document(PageSize.A4);   
		
		// 得到response请求的输出流
		OutputStream os = null;
		//创建一个Excel表
		WritableWorkbook wwb = null;
		OutputStreamWriter osw =null; 
		BufferedWriter bw = null;
		try {	
			os = response.getOutputStream();
			osw = new OutputStreamWriter(os);
		    bw = new BufferedWriter(osw);
		    RtfWriter2.getInstance(document, os);    
			   document.open();    
			   //设置合同头     
			   Paragraph ph = new Paragraph();    
			   Font f  = new Font();    
		       
			   Paragraph p = new Paragraph("aaaaaa",new Font(Font.NORMAL, 18, Font.BOLD, Color.black) );    
			   p.setAlignment(1);    
			   document.add(p);    
			   ph.setFont(f);    
			   document.add(new Paragraph("一、aaaaaa分析",new Font(Font.NORMAL, 16, Font.BOLD, new Color(0, 0, 0))));
			      
			    /*   
			     * 创建有7列的onu运行统计分析(FTTH)表格
			     */   
			   Table table = new Table(7);    
			   table.setBorderWidth(1);  
			   table.setBorderColor(Color.BLACK);    
			   table.setPadding(0);    
			   table.setSpacing(0);    
			   Cell cell = new Cell("aaaaaa(FTTH)");
			   cell.setHeader(true);    
			   cell.setColspan(7);//设置表格为三列     
			   cell.setRowspan(1);//设置表格为三行     
			   table.addCell(cell);    
			   table.endHeaders();// 表头结束  
			   
			   table.addCell("子公司");    
			   table.addCell("总数");    
			   table.addCell("离线数");    
			   table.addCell("断电数");    
			   table.addCell("脱网率");    
			   table.addCell("脱网累计总数");
			   table.addCell("脱网总时长");
			   List list = QueryServiceProvicer.getOpStateStatistic().getOnuOpStatisticAnalysis(1L, times, userId);
			   if(list!= null && list.size()>0){
				   for(int i=0;i<list.size();i++){
					   OnuOpStateStatisticDto dto = (OnuOpStateStatisticDto) list.get(i);
					   table.addCell(dto.getCityName());
					   table.addCell(dto.getOnuCount());
					   table.addCell(dto.getOffLineCount());
					   table.addCell(dto.getPowerOffCount());
					   table.addCell(dto.getOffPrecent());
					   table.addCell(dto.getOffCount());
					   table.addCell(dto.getOffTime());
				   }
			   }
			   document.add(table); 

 

public class BaseAction extends ActionSupport implements SessionAware {

	/**
	 * 
	 */
	private static final long serialVersionUID = 7284375843476500697L;

	private Map session;

	public void setSession(Map arg0) {
		this.session = arg0;
	}

	public void addInfoToSession(String sessKey, Object value) {
		this.session.put(sessKey, value);
	}

	public Object getSessionInfoByKey(String sessKey) {
		return this.session.get(sessKey);
	}
}









public class ExportAction extends BaseAction {
	private Log log = LogFactory.getLog(ExportAction.class);

	public String exportResult(List<Object> dataList, String columns,
			String fileName) throws Exception {
		SimpleDateFormat sf = new SimpleDateFormat("yyyyMMddhhMMss");
		String date = sf.format(new Date());
		if (dataList != null) {
			// 告诉Struts 执行完 Action就行了，不用再去调用结果响应的操作
			ActionContext.getContext().getActionInvocation().getProxy()
					.setExecuteResult(false);
			HttpServletResponse response = ServletActionContext.getResponse();
			// 设置请求的编码方式以及文件的打开类型
			response.setContentType("application/vnd.ms-excel;charset=UTF-8");
			// 设置请求的头文件格式，指定打开的文件的名字，attachment指定浏览器弹出打开、保存对话框
			String fileName1 = fileName + "_" + date + ".xls";
			response.setHeader("Content-Disposition", "attachment; filename="
					+ new String(fileName1.getBytes("gb2312"), "ISO8859-1"));

			// 得到response请求的输出流
			OutputStream os = null;
			// 创建一个Excel表
			WritableWorkbook wwb = null;
			OutputStreamWriter osw = null;
			BufferedWriter bw = null;
			try {
				os = response.getOutputStream();
				osw = new OutputStreamWriter(os);
				bw = new BufferedWriter(osw);
				wwb = Workbook.createWorkbook(os);
				// 建立一个Excel工作簿
				jxl.write.WritableSheet ws1 = wwb.createSheet(fileName + "_"
						+ date, 1);

				// 指定表的列标题
字符串的格式化涉及到的是字体、粗细、字号等元素，这些功能主要由WritableFont和 
WritableCellFormat类来负责
				WritableFont font = new jxl.write.WritableFont(
						WritableFont.ARIAL);// 添加Formatting的对象
				WritableCellFormat format = new jxl.write.WritableCellFormat();
				font.setBoldStyle(WritableFont.BOLD);
				format.setFont(font);
				format.setAlignment(jxl.format.Alignment.CENTRE);
				format.setBackground(Colour.GRAY_25);

				WritableFont headerFont = new jxl.write.WritableFont(
						WritableFont.ARIAL);
				WritableCellFormat headerFormat = new jxl.write.WritableCellFormat();// 表头的格式化
				headerFont.setBoldStyle(WritableFont.BOLD);
				headerFormat.setFont(headerFont);
				headerFormat.setAlignment(jxl.format.Alignment.CENTRE);
// 合并第一列第一行到第九列第一行的所有单元格  
				ws1.mergeCells(0, 0, 8, 0);// 加入第一行
				ws1
						.addCell(new Label(0, 0, fileName + "_" + date,
								headerFormat));
				for (int a = 0; a < columns.split(",").length; a++) {
					ws1.setColumnView(a, 22); // 设置列宽,第m列
					ws1.addCell(new jxl.write.Label(a, 1,
							columns.split(",")[a], format));
				}
//从第三行开始写入内容
				int i = 2;
				jxl.write.WritableCellFormat format_3 = new jxl.write.WritableCellFormat();
				format_3.setAlignment(jxl.format.Alignment.CENTRE);
				for (Object obj : dataList) {
					Object[] object = (Object[]) obj;
					for (int m = 0; m < object.length; m++) {
						if (object[m] == null || object[m].equals("null")) {
							object[m] = "";
						}
						ws1.addCell(new jxl.write.Label(m, i, "" + object[m],
								format_3));
					}
					i++;
				}

				wwb.write();// 写入Exel工作表
				wwb.close();

				bw.flush();
			} catch (Exception e) {
				e.printStackTrace();
			}
			return SUCCESS;
		} else {
			return ERROR;
		}
	}

}
label(a,b,c,headerFormat) a是第一列，b是第一行,c是内容,headerFormat是格式
String columns = "工单号,区域名称,业务号码,业务类型,故障名称,接入方式,发起人,测试状态,测试结论,状态描述,测试开始时间,测试结束时间";
		String fileName = "测试记录";