easyui structs java环境下多级单元格合并及完美导出excel

package com.action; import org.apache.struts2.ServletActionContext; import org.apache.struts2.convention.annotation.Action; import org.apache.struts2.convention.annotation.Namespace; import org.apache.struts2.convention.annotation.Result; import org.springframework.beans.factory.annotation.Autowired; import com.action.base.BaseAction; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableCellFormat; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; import jxl.write.biff.RowsExceededException; @Namespace("/") @Action(value = "xxxxxAction", results = { }) public class XxxxxAction extends BaseAction implements ModelDriven<xx> { public void daochu() throws WriteException, IOException { String content = xx.getIdss(); WritableWorkbook wwb = null; WritableSheet sheet = null; ServletActionContext.getResponse().setContentType("application/vnd.ms-excel"); String sheetName = "Sheet1"; sheetName = sheetName.replaceAll(":", "").replaceAll("[)]", "").replaceAll("[(]", ""); ServletActionContext.getResponse().addHeader("Content-Disposition", "attachment; filename=" + new String(sheetName.getBytes("GBK"), "ISO-8859-1") + ".xls"); OutputStream os = ServletActionContext.getResponse().getOutputStream(); wwb = Workbook.createWorkbook(os); wwb.setProtected(true); sheet = wwb.createSheet(sheetName, 0); int row = 0; int col = 0; Label label = null; if (sheetName.trim().length() > 30) { label = new Label(col, row, sheetName); sheet.addCell(label); row++; } WritableCellFormat cellFormat = new WritableCellFormat(); cellFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE); List listBody = getContent(content); Map<String, Boolean> map = new HashMap<String, Boolean>(); for (Object tdd : listBody) { TD td = (TD) tdd; if (td == null) { row++; col = 0; continue; } if (td.colspan > 1 || td.rowspan > 1) { sheet.mergeCells(col, row, col + td.colspan - 1, row + td.rowspan - 1); for (int i = col; i <= col + td.colspan - 1; i++) { for (int j = row; j <= row + td.rowspan - 1; j++) { map.put(i + "-" + j, true); } } } label = new Label(col, row, td.content); label.setCellFormat(cellFormat); if (td.width != 1) sheet.setColumnView(col, td.width); sheet.addCell(label); map.put(col + "-" + row, true); col += td.colspan; } wwb.write(); wwb.close(); } private String getCaption(String content) { int begin = content.indexOf("<CAPTION"); int end = content.indexOf("</CAPTION>"); if (begin == -1 || end == -1) { return null; } begin = content.indexOf(">", begin); if (begin == -1) { return null; } return content.substring(begin + 1, end); } public List getContent(String content) throws UnsupportedEncodingException { int begin = -1; int end = -1; int index = -1; String numberStr; int number; String[] tables = content.split("</TABLE>"); List list = new ArrayList(); for (int i = 3; i < tables.length; i++) { String table = tables[i]; table = table.replace("</TBODY>", ""); String[] trs = table.split("</TR>"); for (String tr : trs) { number = 1; String[] ss = tr.split("</TD>"); for (String s : ss) { begin = s.indexOf("<TD"); if (begin == -1) { continue; } s = s.substring(begin + 3); index = s.indexOf(">"); TD td = new TD(); begin = s.indexOf("rowSpan="); if (begin != -1) { end = s.indexOf(" ", begin); if (end == -1) { end = index; } numberStr = s.substring(begin + 8, end).replace('"', ' ').replace('\'', ' ').trim(); number = Integer.parseInt(numberStr); td.rowspan = number; } begin = s.indexOf("colSpan="); if (begin != -1) { end = s.indexOf(" ", begin); index = s.indexOf(">", begin); if (end == -1) { end = index; } if (end > index) { end = index; } numberStr = s.substring(begin + 8, end).replace('"', ' ').replace('\'', ' ').trim(); number = Integer.parseInt(numberStr); td.colspan = number; } begin = s.indexOf("DIV style=\"WIDTH: "); if (begin != -1) { end = s.indexOf("px", begin); index = s.indexOf(">", begin); if (end == -1) { end = index; } if (end > index) { end = index; } numberStr = s.substring(begin + 18, end).replace('"', ' ').replace('\'', ' ').trim(); number = Integer.parseInt(numberStr) / 5; td.width = number; } td.content = s.substring(index + 1).replaceAll("\\<.*?\\>", "").replaceAll(" ", "").replaceAll("&nbsp;", "").trim(); list.add(td); } list.add(null); } } return list; } } class TD { int rowspan = 1; int colspan = 1; int width = 1; String content; }