Error Message:
Invalid row number (65536) outside allowable range (0..65535)
Reason:
Invalid row number (65536) outside allowable range (0..65535)
Reason:
When XSSFWorkbook exporting xls, a sheet can only export up to 65535 pieces of data.
Solution:
At the same time, the exported excel file format is changed from XLS to xlsx
Read More:
- Linux: How to Solve jdk11+easy poi Export Excel Error
- [Solved] Java POI Operate Excel error NullPointException
- Java will convert Excel to list set or JSON, export excel file to local, excel import and export, easyexcel tool class
- The number of control threads and concurrency number of concurrent executor of Java starting gun
- Ali easyexcel error: org.apache.poi.ss.usermodel.font.setbold (z) V
- [Solved] POI error: Package should contain a content type part [M1.13]
- [Solved] POI Read excel Error: Your InputStream was neither an OLE2 stream, nor an OOXML stream
- How to convert a Java string into a number (stringtonumber)
- Java: How to use itext to export PDF text absolute positioning (implementation method)
- Gitee Idea Push Error: Invocation failed Server returned invalid Response. java.lang.RuntimeException
- [Solved] Error installing MVN: Java_Home is set to an invalid directory
- Error: Java: invalid target distribution: 9 [How to Solve]
- [Solved] Hibernate Error: Row was updated or deleted by another transaction
- [Solved] tomcat Startup Error: java.lang.SecurityException: Invalid signature file digest for Manifest main attributes
- IntelliJ idea error: e rror:java : invalid source distribution: 11 problem resolution
- Resources is configured in the build of Maven project to prevent the failure of resource export
- [Solved] ERROR: child process failed, exited with error number 100To see additional information in this …
- [Solved] Hibernate Error: java.lang.StackOverflowError at java.lang.Integer.toString(Integer.java:402）
- [Solved] Java: compilation failed: internal java compiler error
- JSON parse error: invalid UTF-8 solution series [How to Solve]