很多天了,一直未能解决,今天再顶!Event-Driven Reading The event-driven API for reading documents is a little more complicated and requires that your application know, in advance, which files it wants to read. The benefit of using this API is that each document is in memory just long enough for your application to read it, and documents that you never read at all are not in memory at all. When you're finished reading the documents you wanted, the file system has no data structures associated with it at all and can be discarded.但是一直找不到相关操作的例子,不知道POIFSReaderListener实现接口类中具体如何获取HSSFRow实例?
一個單元格最多有多少個字符。excel不是無限大的。當大於最大值時就會出錯了。個人意見!
Event-Driven Reading The event-driven API for reading documents is a little more complicated and requires that your application know, in advance, which files it wants to read. The benefit of using this API is that each document is in memory just long enough for your application to read it, and documents that you never read at all are not in memory at all. When you're finished reading the documents you wanted, the file system has no data structures associated with it at all and can be discarded.但是一直找不到相关操作的例子,不知道POIFSReaderListener实现接口类中具体如何获取HSSFRow实例?
我10万都没有问题的,你虚拟机内存设过没有,报out of memory还是什么溢出,把错误贴上来
excel有限制。
The event-driven API for reading documents is a little more complicated and requires that your application know, in advance, which files it wants to read. The benefit of using this API is that each document is in memory just long enough for your application to read it, and documents that you never read at all are not in memory at all. When you're finished reading the documents you wanted, the file system has no data structures associated with it at all and can be discarded.但是一直找不到相关操作的例子,不知道POIFSReaderListener实现接口类中具体如何获取HSSFRow实例?
The event-driven API for reading documents is a little more complicated and requires that your application know, in advance, which files it wants to read. The benefit of using this API is that each document is in memory just long enough for your application to read it, and documents that you never read at all are not in memory at all. When you're finished reading the documents you wanted, the file system has no data structures associated with it at all and can be discarded.但是一直找不到相关操作的例子,不知道POIFSReaderListener实现接口类中具体如何获取HSSFRow实例?
数据量大时内存溢出,建议边读数据库边写入excel,这样的话可以达到20m;我把结果集放到hashtable,vecter中让后再写入excel,就会出现内存溢出现象。调jvm的内存也是一个办法,如果注意要调整服务器虚拟内存;