| | |
| | | |
| | | import com.alibaba.excel.write.metadata.style.WriteCellStyle; |
| | | import com.alibaba.excel.write.metadata.style.WriteFont; |
| | | import com.yuanchu.mom.pojo.AuxiliaryOutputWorkingHours; |
| | | import org.apache.poi.ss.usermodel.*; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.stream.Collectors; |
| | | |
| | | public class StyleYearUtils { |
| | | /** |
| | | * 标题样式 |
| | | * |
| | | * @return |
| | | */ |
| | | public static WriteCellStyle getHeadStyle(){ |
| | | public static WriteCellStyle getHeadStyle() { |
| | | // 头的策略 |
| | | WriteCellStyle headWriteCellStyle = new WriteCellStyle(); |
| | | // 背景颜色 |
| | |
| | | // 字体 |
| | | WriteFont headWriteFont = new WriteFont(); |
| | | headWriteFont.setFontName("仿宋");//设置字体名字 |
| | | headWriteFont.setFontHeightInPoints((short)9);//设置字体大小 |
| | | headWriteFont.setFontHeightInPoints((short) 9);//设置字体大小 |
| | | headWriteFont.setBold(true);//字体加粗 |
| | | headWriteFont.setColor((short) 1); |
| | | headWriteCellStyle.setWriteFont(headWriteFont); //在样式用应用设置的字体; |
| | |
| | | |
| | | /** |
| | | * 内容样式 |
| | | * |
| | | * @return |
| | | */ |
| | | public static WriteCellStyle getContentStyle(){ |
| | | public static WriteCellStyle getContentStyle() { |
| | | // 内容的策略 |
| | | WriteCellStyle contentWriteCellStyle = new WriteCellStyle(); |
| | | |
| | |
| | | |
| | | return contentWriteCellStyle; |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | |
| | | String a="[\"GB/T 15972.20-2021\",\"IEC 60793-1-20:2014\"]"; |
| | | System.out.println(a.contains("GB/T 15972.20-2021")); |
| | | } |
| | | } |