场景: 获取第一个excel的单元格的背景(前景)色设置在第二个excel的单元格上。 在调用第一个excel对象的getFillForegroundColor()获取前景色索引后,调用第二个excel对象的setFillForegroundColor()写入获取到的背景色后,发现写出的第二个excel颜色混乱,发现getFillForegroundColor返回的值都是64。(ps:查看官网api发现调用getFillForegroundColor()方法默认是返回64。) 问题: work
报错:
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
at java.util.ArrayList.rangeCheck(ArrayList.java:657)
at java.util.ArrayList.get(ArrayList.java:433)
at org.apache.poi.xssf.model.StylesTable.getBorderAt(StylesTable.java:251)
at org.apache.poi.xssf.usermodel.XSSFCellStyle.getBorderLeft(XSSFCellStyle.java:282)
at com.currency.generaldelivery.excel.handler.factory.support.PoiExcelNativeFactory.creatCell(PoiExcelNativeFactory.java:120)
at com.currency.generaldelivery.excel.handler.factory.support.PoiExcelNativeFactory.creatRow(PoiExcelNativeFactory.java:105)
at com.currency.generaldelivery.excel.handler.factory.support.PoiExcelNativeFactory.createSheetAt(PoiExcelNativeFactory.java:74)
at com.currency.generaldelivery.excel.handler.factory.support.PoiExcelNativeFactory.createWorkbook(PoiExcelNativeFactory.java:63)
at com.currency.generaldelivery.excel.handler.factory.support.PoiExcelNativeFactory.createHeadWorkbook(PoiExcelNativeFactory.java:36)
at com.currency.generaldelivery.PoiUtilTest.testCreatePOI(PoiUtilTest.java:64)
at com.currency.generaldelivery.PoiUtilTest.main(PoiUtilTest.java:105)