在使用java读写excel文件的时候突然出现了下面的异常:
Exception in thread "main" java.lang.IllegalArgumentException: Invalid row number (-32536) outside allowable range (0..1048575)
at org.apache.poi.xssf.usermodel.XSSFRow.setRowNum(XSSFRow.java:335)
at org.apache.poi.xssf.usermodel.XSSFSheet.createRow(XSSFSheet.java:538)
at org.apache.poi.xssf.usermodel.XSSFSheet.createRow(XSSFSheet.java:71)
at com.jp.WriterExcelUtil.generateWorkbook(WriterExcelUtil.java:99)
at com.jp.WriterExcelUtil.writerExcel(WriterExcelUtil.java:64)
at com.jp.ReadExcelUtils.readExcelContent(ReadExcelUtils.java:196)
at com.jp.ModifyExcelContent.main(ModifyExcelContent.java:19)
可是在上一次测试的时候,程序是没有问题的,经过查证发现是,rownumber的数量强制转换成了short,所以发生了异常。