使用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>