使用poi导出excel时:报错:java.lang.IllegalArgumentException: Maximum column number is 255
poi生成excel文件时报错,解决方法:
1.将文件名后缀.xls改成.xlsx
2.使用的类HSSFWorkbook、HSSFSheet等修改为XSSFWorkbook、XSSFSheet
3.使用XSSFWorkbook需要引入相应的JAR包,版本要保持一致
<dependency> <groupId>org.apache.poigroupId> <artifactId>poiartifactId> <version>3.14version> dependency> <dependency> <groupId>org.apache.poigroupId> <artifactId>poi-ooxmlartifactId> <version>3.14version> dependency> <dependency> <groupId>org.apache.poigroupId> <artifactId>poi-ooxml-schemasartifactId> <version>3.14version> dependency>