FileInputStream不行,那你用BufferedInputStream来试试,看是否可以呢,我也没试过这么大的excel文件。
解决方案 »
- JDK连接mysql
- hibernate中List集合不能用日期排序?
- Integer praseInt 如果输入是"1024MB" 怎样返回是1024而不是直接异常
- EJB和SSH的优缺点比较
- Hibernate: 求一hql的写法
- javaMail问题
- 我干了2年java程序员,一直写程序,现在公司想让我做设计工作,不知道我需要提升哪些能力,做哪些准备,有没有好的资料推荐一下,谢谢大
- 有人用Eclipse3+Tomcat5.0.27+Lomboz3.1.0的吗?
- 请教关于 JTabbedPane 和jtree 结合的问题!
- Java连接oracle8.16出问题,请帮忙解决!
- 给别人做网站,需要我做哪些准备
- J2EE开发小组 群号码:17423426 欢迎加入
我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的内存也是一个办法,如果注意要调整服务器虚拟内存;