导出Excel样式设计方法.DOC

《导出Excel样式设计方法.DOC》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Ïê½âJAVAPOIµ¼³öEXCEL±¨±íµÄ²Ù×÷(°üÀ¨¸÷ÖÖ¸ñʽ¼°ÑùʽµÄʵÏÖ)²©¿Í·ÖÀࣺJAVA¿ª·¢¼¼ÊõÏê½âExcelJavaÖмä¼þJ#¹¤×÷ÕâÁ½ÌìÔÚ×öÏîĿʱ£¬×îºóÒ»µÀ¹¤ÐòΪ½«²éѯµÄ±¨±íµ¼³öΪEXCEL£¬ÒòΪÒÔǰûÓÐÕâ·½ÃæµÄ¾Ñ飬ËùÒÔÒ²ÔÚÍøÉÏÕÒÁËЩ×ÊÁÏ£¬×ßÁËЩÍä·£¬µ«Ä¿Ç°ËùÓеÄÎÊÌⶼÒѽâ¾ö£¬¶øÇÒ×ÔÈÏ

2、ΪÕâ¸ö±¨±í»¹ÊÇÓÐЩÄѶȵģ¬ÔÚ´ËÎÒ½«Õâ¸ö¸´ÔÓ±¨±íµÄËùÓдúÂëÌù³öÀ´£¬´úÂëµÄ×¢ÊͱȽÏÏêϸ£¬Ï£ÍûѧϰPOIµÄÐÖµÜÃÇ¿ÉÒԲο¼Ï£¬½¨Òé´ó¼Ò°Ñ´úÂëÖ±½ÓÌùµ½JAVA¹¤³ÌÖÐÏÈÅÜÆðÀ´£¬Õâ¶Î´úÂë»áÔÚCÅÌÏÂÉú³ÉÒ»¸öEXCELÎļþ£¬Èç¹û´ó¼Ò¶Ô×ÅÕâ¸öEXCELÎļþÀ´¶ÁÕâЩ´úÂëµÄ»°Ó¦¸ÃÉÏÊֱȽϿ죬ºÃÁË£

3、¬·Ñ»°²»¶à˵£¬Çë¿´´úÂ룺һ¡¢¹¤¾ßÀà/***EXCEL±¨±í¹¤¾ßÀà.**@authorcaoyb*@version$Revision:$*/publicclassExportExcel{privateHSSFWorkbookwb=null;privateHSSFSheetsheet=null;/***@paramwb*@paramsheet*/publicExportExcel(HSSFWorkbookwb,HSSFSheetsheet){super();this.w

4、b=wb;this.sheet=sheet;}/***@returnthesheet*/publicHSSFSheetgetSheet(){returnsheet;}/***@paramsheetthesheettoset*/publicvoidsetSheet(HSSFSheetsheet){this.sheet=sheet;}/***@returnthewb*/publicHSSFWorkbookgetWb(){returnwb;}/***@paramwbthewbtoset*/publicvoids

5、etWb(HSSFWorkbookwb){this.wb=wb;}/***´´½¨Í¨ÓÃEXCELÍ·²¿**@paramheadStringÍ·²¿ÏÔʾµÄ×Ö·û*@paramcolSum¸Ã±¨±íµÄÁÐÊý*/publicvoidcreateNormalHead(StringheadString,intcolSum){HSSFRowrow=sheet.createRow(0);//ÉèÖõÚÒ»ÐÐHSSFCellcell=row.createCell(0);row.setHeight(

6、(short)400);//¶¨Òåµ¥Ôª¸ñΪ×Ö·û´®ÀàÐÍcell.setCellType(HSSFCell.ENCODING_UTF_16);cell.setCellValue(newHSSFRichTextString("ÄϾ©³ÇÇø¸÷Íøµã½ø¼þͳ¼Æ±¨±í"));//Ö¸¶¨ºÏ²¢ÇøÓòsheet.addMergedRegion(newRegion(0,(short)0,0,(short)colSum));HSSFCellStylecellStyle=wb.crea

7、teCellStyle();cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);//Ö¸¶¨µ¥Ôª¸ñ¾ÓÖжÔÆëcellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//Ö¸¶¨µ¥Ôª¸ñ´¹Ö±¾ÓÖжÔÆëcellStyle.setWrapText(true);//Ö¸¶¨µ¥Ôª¸ñ×Ô¶¯»»ÐÐ//ÉèÖõ¥Ôª¸ñ×ÖÌåHSSFFontfont=wb.crea

8、teFont();font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);font.setFontName("ËÎÌå");font.setFontHeight((short)300);cellStyle.setFont(font);cell.setCellStyle(cellStyle);}/***´´½¨Í¨Óñ¨±íµÚ¶þÐÐ**@paramparamsͳ¼ÆÌõ¼þÊý×é*@p