public static HSSFFont getMergeConflictFont(HSSFWorkbook wb) {
fontStyle = wb.createFont();
fontStyle.setFontName("Arial");
fontStyle.setFontHeightInPoints((short)12);
fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
return fontStyle;
}
/*设置Excel单元格格式,引用到字体格式*/
public static HSSFCellStyle getAnyCellStyle(HSSFWorkbook wb,HSSFFont font,short align,short valign,short indent,boolean wrapText) {
cellStyle =wb.createCellStyle();
if(font != null) cellStyle.setFont(font);
if(align > 0) cellStyle.setAlignment(align);
if(valign > 0) cellStyle.setVerticalAlignment(valign);
if(indent > 0) cellStyle.setIndention(indent);
cellStyle.setWrapText(wrapText);
return cellStyle;
}
/*设置Excel单元格行高、列宽*/
public static void setDefaultHighWidth(HSSFSheet sheet) {
sheet.setDefaultRowHeightInPoints(10);
sheet.setDefaultColumnWidth((short) 20);
}
public static void setDefaultCellHighWidthInRange(HSSFSheet sheet,short[] eachCellWidth,int high) {
//青年人网提示：假定第一行和第一行所需的单元个已经建立好了，也就是说，在这之前已经调用了DesignXlsHeaderFooter.setXlsHeader
sheet.setDefaultRowHeightInPoints(high);//设置默认高
/*设置各列单元格宽度*/
for(int i = 0;i < eachCellWidth.length;i++) {
//System.out.print(""+i+"\t");
sheet.setColumnWidth((short) i,(short) ((eachCellWidth[i])*256));
}
//System.out.println();
/*
Iterator arrayItr = eachCellWidth.iterator();
short width;
short pos = 0;
while(arrayItr.hasNext()) {
width = Short.parseShort((String)arrayItr.next());
sheet.setColumnWidth(pos,width);
pos++;
}
*/
}//end_setDefaultCellHighWidthInRange
}
责任编辑：小草
