使用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.poi</groupId> <artifactId>poi</artifactId> <version>3.14</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.14</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml-schemas</artifactId> <version>3.14</version> </dependency>