• Home
• com.github.houbb
• iexcel
• 0.0.9
• source code
• 02-poi-jlx.md

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

wiki.02-poi-jlx.md Maven / Gradle / Ivy

# poi

apache 工具

[sax 模式](https://poi.apache.org/components/spreadsheet/how-to.html#xssf_sax_api)

[SAX解析excel，避免oom](https://blog.csdn.net/weixin_42330218/article/details/81368034?utm_source=blogxgwz2)

[SAX解析excel与DOM解析excel占用内存对比](https://blog.csdn.net/weixin_42330218/article/details/81458443)

[秒懂POI解析excel，SAXParser解析大xlsx，XSSFReader处理包括被忽略的空单元格处理](https://blog.csdn.net/c5113620/article/details/79780500)

两种 excel 的区别

[POI-HSSF and POI-XSSF/SXSSF - Java API To Access Microsoft Excel Format Files](https://poi.apache.org/components/spreadsheet/index.html)

http://www.datypic.com/sc/ooxml/ss.html


## 解决 OOM 的方式

[使用POI进行数据导出excel时的OOM服务挂掉，cpu飙升的问题](https://blog.csdn.net/doujinlong1/article/details/80780823)

# jxl

[jxl 介绍](https://blog.csdn.net/qq_37057095/article/details/75460346)

[jxl 封装](https://github.com/huangyemin/JxlExcel)

已经停止更新。比较老的框架。