java poi对excel处理用jsp显示处理(二)

2014-11-24 01:00:33 · 作者: · 浏览: 2
);
sb.append("查看全部结果 ");
sb.append("
");
sb
.append(" ");
sb.append("
");
sb.append(" sb.append("border="0" cellspacing="0" cellpadding="0"> ");

sb.append("

");
sb.append(" ");
sb.append(" ");
sb.append(" ");
sb.append("
");
return sb;
}

public StringBuffer bodyHtmlEnd() {
StringBuffer sb = new StringBuffer("");
sb.append(" ");
sb.append(" ");
return sb;
}

private int getTdWidth(Sheet sheet, int startCol, int endCol) {
int tdwidth = 0;
for (int i = startCol; i <= endCol; i++) {
int tempwidth = sheet.getColumnWidth(i) / 32;
tdwidth = tdwidth + tempwidth;

}
return tdwidth;
}

public StringBuffer excelToHtmlJs(HSSFWorkbook workbook, int sheetindex) {
StringBuffer sb = new StringBuffer("");

HSSFSheet sheet = workbook.getSheetAt(sheetindex);

int lastRowNum = sheet.getLastRowNum();
System.out.println("lastRowNum=" + lastRowNum);
Map map[] = getRowSpanColSpanMap(sheet);

HSSFRow row1 = null;
HSSFCell cell1 = null;
int lastColNums=0;
for (int rowNum = sheet.getFirstRowNum(),i=0; rowNum <= lastRowNum; rowNum++,i++) {
row1 = (HSSFRow) sheet.getRow(rowNum);

if ( !" ".equals(row1)) {
lastColNums = row1.getLastCellNum();
int sumWidth=0;// 求头部的总width
System.out.println("lastColNums:"+lastColNums);
}

// break;


for (int colNum = 0,j=0; colNum < lastColNums; colNum++,j++) {
cell1 = row1.getCell(colNum);
int tdwidth = sheet.getColumnWidth(colNum) / 32;
//求头的总的width
// System.out.println("tdwidth="+tdwidth);
sumWidth+=tdwidth;
this.setSumWidth(sumWidth);
System.out.println("tdwidth="+tdwidth);


}
break;
}

sb.append("<