poi从3.x升版到4.0以上和poi-tl从1.5.x升版到1.10.x以上

开发过程中碰到poi版本需要升级

pom.xml

<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi-scratchpad</artifactId>
   <version>4.1.2</version>
</dependency>


<!-- POI -->
<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi</artifactId>
   <version>4.1.2</version>
</dependency>
<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi-ooxml</artifactId>
   <version>4.1.2</version>
</dependency>
<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi-ooxml-schemas</artifactId>
   <version>4.1.2</version>
</dependency>


<!-- poi-tl -->
<dependency>
   <groupId>com.deepoove</groupId>
   <artifactId>poi-tl</artifactId>
   <version>1.10.0</version>
</dependency>

<!-- easypoi3.2升版到4.0 不继承common -->
<dependency>
   <groupId>com.equipment</groupId>
   <artifactId>equipment-common-module</artifactId>
   <version>2.1.0</version>


   <exclusions>
      <exclusion>
         <groupId>cn.afterturn</groupId>
         <artifactId>easypoi-base</artifactId>
      </exclusion>
   </exclusions>
</dependency>
<dependency>
   <groupId>cn.afterturn</groupId>
   <artifactId>easypoi-base</artifactId>
   <version>4.0.0</version>
</dependency>

poi-tl导出Word模版的列表循环要改，图片要改

poi 样式要修改

titleStyle.setAlignment(HorizontalAlignment.CENTER); // 居中

titleStyle.setBorderBottom(BorderStyle.THIN); //下边框

titleStyle.setBorderLeft(BorderStyle.THIN);//左边框

titleStyle.setBorderTop(BorderStyle.THIN);//上边框

titleStyle.setBorderRight(BorderStyle.THIN);//右边框

poi版本4.0及以上判断单元格为空：

easypoi从3.2升版到4.0

WordImageEntity失效没有了，替换为 ImageEntity

/**
* 导出图片 （3.2版本的）
* imageUrl 图片地址
* heigh
* width
*/
public static WordImageEntity getImage(String imageUrl, Integer heigh, Integer width){
    //取图片二进制
    byte[] netImgByUrl = getNetImgByUrl(imageUrl);
    WordImageEntity image = new WordImageEntity();
    image.setHeight(heigh);
    image.setWidth(width);
    image.setData(netImgByUrl);
    image.setType(WordImageEntity.Data);
    return image;
}



/**
* 导出图片 （4.0以上版本）
* imageUrl 图片地址
* heigh
* width
*/
public static ImageEntity getImage(String imageUrl, Integer heigh, Integer width){
    //取图片二进制
    byte[] netImgByUrl = getNetImgByUrl(imageUrl);
    ImageEntity image = new ImageEntity();
    image.setHeight(heigh);
    image.setWidth(width);
    image.setData(netImgByUrl);
    image.setType(ImageEntity.Data);
    return image;
}

net.sf.jxls1.0.6中getCellType()和org.apache.poi4.1.2不匹配报错问题，只支持到3.9，且jxls已经停更了不维护了，网上看到的方法是自己修改源码，修改返回值类型等