Apache POI SXSSFWorkbook createSheet()报错空指针

记一次poi的报错

在多个环境下都没有出现问题 使用docker后使用就报错空指针 打log定位

报错信息

java.lang.NullPointerException
 	at sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264)
 	at sun.awt.FontConfiguration.readFontConfigFile(FontConfiguration.java:219)
 	at sun.awt.FontConfiguration.init(FontConfiguration.java:107)
 	at sun.awt.X11FontManager.createFontConfiguration(X11FontManager.java:774)
 	at sun.font.SunFontManager$2.run(SunFontManager.java:431)
 	at java.security.AccessController.doPrivileged(Native Method)
 	at sun.font.SunFontManager.<init>(SunFontManager.java:376)
 	at sun.awt.FcFontManager.<init>(FcFontManager.java:35)
 	at sun.awt.X11FontManager.<init>(X11FontManager.java:57)
 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
 	at java.lang.Class.newInstance(Class.java:442)
 	at sun.font.FontManagerFactory$1.run(FontManagerFactory.java:83)
 	at java.security.AccessController.doPrivileged(Native Method)
 	at sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74)
 	at java.awt.Font.getFont2D(Font.java:491)
 	at java.awt.Font.canDisplayUpTo(Font.java:2060)
 	at java.awt.font.TextLayout.singleFont(TextLayout.java:470)
 	at java.awt.font.TextLayout.<init>(TextLayout.java:531)
 	at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:285)
 	at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.<init>(AutoSizeColumnTracker.java:117)
 	at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:89)
 	at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:701)
 	at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:722)
 	at com.autotollintl.report.service.report.impl.TemperatureReportServiceImpl.excelProcess(TemperatureReportServiceImpl.java:234)
 	at com.autotollintl.report.util.ThreadProcessUtil.lambda$null$0(ThreadProcessUtil.java:38)
 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 	at java.lang.Thread.run(Thread.java:748)

问题

源于docker种缺少字体库导致的报空指针 具体可以看参考文章很详细

解决方法

1. 更换jdk版本，不使用opeanjdk
2. 下载字体库到docker中

RUN apk add --update font-adobe-100dpi ttf-dejavu fontconfig

参考文章：使用SXSSF导出Excel时createSheet空指针解决方案

其他文章：Apache POI XSSFWorkbook报错空指针