poi4.0版本之后操作execl改动以及4.0版本所需jar包

poi4.0版本常用变动

1、setAlignment(CellStyle.ALIGN_CENTER)
修改为setAlignment(HorizontalAlignment.CENTER);

2、setVerticalAlignment(CellStyle.VERTICAL_CENTER);
修改为setVerticalAlignment(VerticalAlignment.CENTER);

3、setBoldweight(Font.BOLDWEIGHT_BOLD);
修改为setBold(true);

4、setBorderRight(CellStyle.BORDER_THIN);
修改为setBorderRight(BorderStyle.THIN);

5、setBorderLeft(CellStyle.BORDER_THIN);
修改为setBorderLeft(BorderStyle.THIN);

6、style.setBorderTop(CellStyle.BORDER_THIN);
修改为setBorderTop(BorderStyle.THIN);

7、setBorderBottom(CellStyle.BORDER_THIN);
修改为setBorderBottom(BorderStyle.THIN);

8、setFillPattern(CellStyle.SOLID_FOREGROUND);
修改为setFillPattern(FillPatternType.SOLID_FOREGROUND);

poi4.0版本之后所需jar

commons-compress-1.21.jar
commons-collections4-4.1.jar
xmlbeans-3.0.2.jar
poi-ooxml-schemas-4.1.2.jar
poi-ooxml-4.1.2.jar
poi-4.1.2.jar