I need to read very large excel files (say 5GB) from S3bucket. but I am getting org.apache.poi.util.RecordFormatException for files more than 10Mb. I am using Apache poi. I need to extract data from multiple sheets seperately inside the input excel file after reading. So, I can't use SXSSF as it reads whole data into single sheet. Can anyone suggest me a way to sort my issue!!
我需要从S3bucket中读取非常大的excel文件(比如5GB)。但对于超过10Mb的文件,我得到了org.apache.poi.util.RecordFormatException。我正在使用Apache poi。阅读后,我需要从输入的excel文件中的多张表中分别提取数据。所以,我不能使用SXSSF,因为它将整个数据读取到一张表中。有人能给我一个解决问题的方法吗!!
I tried Apache poi, all types of workbooks (xssfWorkbook, sxssf,etc.,) nothing worked out I am unable to fetch data from excel. I tried to print sheet names it worked for below 10Mb not for above
我尝试了Apache poi,所有类型的工作簿(xssfWorkbook、sxsf等)都没有成功——我无法从excel中获取数据。我试着打印纸张名称,它在10Mb以下有效,而在10Mb以上无效
更多回答
优秀答案推荐
我是一名优秀的程序员,十分优秀!