package *.*;
import java.util.ArrayList;
import java.util.IteraTor;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class FontCellStyle. {
private static HSSFFont fontStyle. = null;
private static HSSFCellStyle. cellStyle. = null;
/*设置字体格式*/
public static HSSFFont getHdrFont(HSSFWorkbook wb) {
fontStyle. = wb.createFont();
fontStyle.setFontName(“宋体”);
fontStyle.setFontHeightInPoints((short)20);
fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
return fontStyle;
}
public static HSSFFont getFtrFont(HSSFWorkbook wb) {
fontStyle. = wb.createFont();
fontStyle.setFontName(“宋体”);
fontStyle.setFontHeightInPoints((short)12);
fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
return fontStyle;
}
public static HSSFFont getContentFont(HSSFWorkbook wb) {
fontStyle. = wb.createFont();
fontStyle.setFontName(“宋体”);
fontStyle.setFontHeightInPoints((short)12);
fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
return fontStyle;
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
}
/*调用方式*/
/*设置整体excel单元格格式*/
FileOutputStream fos = null;
try {
fos = new FileOutputStream(rptRealPathAndName);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
//System.out.println(“创建文件失败。。。”);
log.info(“In WriteRptByType.writeRptTypeFive(),create file failed!!!”);
log.error(e.getMessage());
//e.printStackTrace();
return -1;
}
HSSFWorkbook workBook = new HSSFWorkbook();
HSSFSheet sheet = workBook.createSheet();;
workBook.setSheetName(0,”移动”,HSSFWorkbook.ENCODING_UTF_16);
HSSFCellStyle. cellStyleHdr = FontCellStyle.getAnyCellStyle(workBook,FontCellStyle.getHdrFont(workBook),HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short)-1, true);
HSSFRow curRow = sheet.createRow(0);
HSSFCell curCell= curRow.createCell((short)0);
curCell.setEncoding(HSSFCell.ENCODING_UTF_16);
curCell.setCellStyle(cellStyleHdr );
curCell.setCellValue(“可以写入汉字，无乱码”);
/*………….写入文件………….*/
try {
workBook.write(fos);
fos.close();
} catch (IOException e) {
// TODO Auto-generated catch block
//System.out.println(“写错误。。。”);
succFlag = -1;
log.error(“报表写错误：”+e.getMessage());
//e.printStackTrace();
一起交流学习请访问：Tore_m_1206686_21115_1_1.html”>http://www.shangxueba.com/sTore_m_1206686_21115_1_1.html
爱的力量大到可以使人忘记一切，
