加瓦 发表于 2018-1-9 16:41:06

数据导出失败 Invalid column index (256)poi jar包一改就报错，求助

Invalid column index (256).Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
java.lang.IllegalArgumentException: Invalid column index (256).Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
        at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:939)
        at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:153)
        at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:148)
        at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:126)
        at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:39)
        at org.jeecgframework.poi.excel.export.base.ExcelExportBase.createStringCell(ExcelExportBase.java:222)
        at org.jeecgframework.poi.excel.export.ExcelExportServer.createHeaderRow(ExcelExportServer.java:82)
        at org.jeecgframework.poi.excel.export.ExcelExportServer.createHeaderAndTitle(ExcelExportServer.java:62)

加瓦 发表于 2018-1-9 16:44:19

各位大神求助啊:'(

novel608 发表于 2018-1-9 18:52:11

麻烦提供下更详细的信息

加瓦 发表于 2018-1-10 11:51:31

novel608 发表于 2018-1-9 18:52 static/image/common/back.gif
麻烦提供下更详细的信息

非常感谢您能回复，我已经将问题解决，就是因为我需要导出的字段超过了256，将原来的HSSF改为XSSF,导出数据就可以了，方便加个好友吗？以后不懂的好请教一下您
页: [1]
查看完整版本: 数据导出失败 Invalid column index (256)poi jar包一改就报错，求助