copy from performance-server/src/main/java/com/yuanchu/mom/utils/StyleUtils.java
copy to performance-server/src/main/java/com/yuanchu/mom/utils/StyleMonthUtils.java
| Îļþ´Ó performance-server/src/main/java/com/yuanchu/mom/utils/StyleUtils.java ¸´ÖÆ |
| | |
|---|
| | | import com.alibaba.excel.write.metadata.style.WriteFont; |
|---|
| | | import org.apache.poi.ss.usermodel.*; |
|---|
| | | |
|---|
| | | public class StyleUtils { |
|---|
| | | public class StyleMonthUtils { |
|---|
| | | /** |
|---|
| | | * æ é¢æ ·å¼ |
|---|
| | | * @return |
|---|
| | |
|---|
| | | // 头ççç¥ |
|---|
| | | WriteCellStyle headWriteCellStyle = new WriteCellStyle(); |
|---|
| | | // èæ¯é¢è² |
|---|
| | | headWriteCellStyle.setFillForegroundColor(IndexedColors.LIME.getIndex()); |
|---|
| | | headWriteCellStyle.setFillForegroundColor(IndexedColors.WHITE1.getIndex()); |
|---|
| | | headWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND); |
|---|
| | | |
|---|
| | | // åä½ |
|---|
| | | WriteFont headWriteFont = new WriteFont(); |
|---|
| | | headWriteFont.setFontName("仿å®");//设置åä½åå |
|---|
| | | headWriteFont.setFontName("ç线");//设置åä½åå |
|---|
| | | headWriteFont.setFontHeightInPoints((short)9);//设置åä½å¤§å° |
|---|
| | | headWriteFont.setBold(true);//åä½å ç² |
|---|
| | | headWriteFont.setColor((short) 1); |
|---|
| | | headWriteFont.setColor((short) 0); |
|---|
| | | headWriteCellStyle.setWriteFont(headWriteFont); //å¨æ ·å¼ç¨åºç¨è®¾ç½®çåä½; |
|---|
| | | |
|---|
| | | // æ ·å¼ |
|---|
| | | headWriteCellStyle.setBorderBottom(BorderStyle.THIN);//设置åºè¾¹æ¡; |
|---|
| | | headWriteCellStyle.setBottomBorderColor((short) 1);//设置åºè¾¹æ¡é¢è²; |
|---|
| | | headWriteCellStyle.setBottomBorderColor((short) 0);//设置åºè¾¹æ¡é¢è²; |
|---|
| | | headWriteCellStyle.setBorderLeft(BorderStyle.THIN); //设置左边æ¡; |
|---|
| | | headWriteCellStyle.setLeftBorderColor((short) 1);//设置左边æ¡é¢è²; |
|---|
| | | headWriteCellStyle.setLeftBorderColor((short) 0);//设置左边æ¡é¢è²; |
|---|
| | | headWriteCellStyle.setBorderRight(BorderStyle.THIN);//设置å³è¾¹æ¡; |
|---|
| | | headWriteCellStyle.setRightBorderColor((short) 1);//设置å³è¾¹æ¡é¢è²; |
|---|
| | | headWriteCellStyle.setRightBorderColor((short) 0);//设置å³è¾¹æ¡é¢è²; |
|---|
| | | headWriteCellStyle.setBorderTop(BorderStyle.THIN);//设置顶边æ¡; |
|---|
| | | headWriteCellStyle.setTopBorderColor((short) 1); //设置顶边æ¡é¢è²; |
|---|
| | | headWriteCellStyle.setTopBorderColor((short) 0); //设置顶边æ¡é¢è²; |
|---|
| | | |
|---|
| | | headWriteCellStyle.setWrapped(false); //设置èªå¨æ¢è¡; |
|---|
| | | |
|---|
| | |
|---|
| | | WriteCellStyle contentWriteCellStyle = new WriteCellStyle(); |
|---|
| | | |
|---|
| | | // è¿ééè¦æå® FillPatternType 为FillPatternType.SOLID_FOREGROUND ä¸ç¶æ æ³æ¾ç¤ºèæ¯é¢è².头é»è®¤äº FillPatternTypeæ以å¯ä»¥ä¸æå® |
|---|
| | | contentWriteCellStyle.setFillForegroundColor(IndexedColors.LIGHT_GREEN.getIndex()); |
|---|
| | | // contentWriteCellStyle.setFillForegroundColor(IndexedColors.LIGHT_GREEN.getIndex()); |
|---|
| | | contentWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND); |
|---|
| | | |
|---|
| | | // 设置åä½ |
|---|
| | | WriteFont contentWriteFont = new WriteFont(); |
|---|
| | | contentWriteFont.setFontHeightInPoints((short) 9);//设置åä½å¤§å° |
|---|
| | | contentWriteFont.setFontName("仿å®"); //设置åä½åå |
|---|
| | | contentWriteFont.setFontHeightInPoints((short) 10);//设置åä½å¤§å° |
|---|
| | | contentWriteFont.setFontName("ç线"); //设置åä½åå |
|---|
| | | contentWriteCellStyle.setWriteFont(contentWriteFont);//å¨æ ·å¼ç¨åºç¨è®¾ç½®çåä½; |
|---|
| | | |
|---|
| | | //è®¾ç½®æ ·å¼; |
|---|
| | | // contentWriteCellStyle.setBorderBottom(BorderStyle.THIN);//设置åºè¾¹æ¡; |
|---|
| | | // contentWriteCellStyle.setBottomBorderColor((short) 1);//设置åºè¾¹æ¡é¢è²; |
|---|
| | | contentWriteCellStyle.setBorderBottom(BorderStyle.THIN);//设置åºè¾¹æ¡; |
|---|
| | | contentWriteCellStyle.setBottomBorderColor((short) 0);//设置åºè¾¹æ¡é¢è²; |
|---|
| | | contentWriteCellStyle.setBorderLeft(BorderStyle.THIN); //设置左边æ¡; |
|---|
| | | contentWriteCellStyle.setLeftBorderColor((short) 1);//设置左边æ¡é¢è²; |
|---|
| | | contentWriteCellStyle.setLeftBorderColor((short) 0);//设置左边æ¡é¢è²; |
|---|
| | | contentWriteCellStyle.setBorderRight(BorderStyle.THIN);//设置å³è¾¹æ¡; |
|---|
| | | contentWriteCellStyle.setRightBorderColor((short) 1);//设置å³è¾¹æ¡é¢è²; |
|---|
| | | contentWriteCellStyle.setRightBorderColor((short) 0);//设置å³è¾¹æ¡é¢è²; |
|---|
| | | contentWriteCellStyle.setBorderTop(BorderStyle.THIN);//设置顶边æ¡; |
|---|
| | | contentWriteCellStyle.setTopBorderColor((short) 1); ///设置顶边æ¡é¢è²; |
|---|
| | | contentWriteCellStyle.setTopBorderColor((short) 0); ///设置顶边æ¡é¢è²; |
|---|
| | | |
|---|
| | | contentWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);// æ°´å¹³å±
ä¸ |
|---|
| | | contentWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);// åç´å±
ä¸ |
|---|
