EasyPoi - Easy utility classes of Excel and Word
===========================
Easypoi, as is clear from the name, it's easy for a developer who never even used poi to
export/import Excel, export Excel Template and Word Template, and export PDF. We encapsulate Apache poi in the upper layers.
With simple annotations and templates Language (familiar expression syntax) to accomplish previously complex coding.
Website:http://www.wupaas.com/
Email: [email protected]
Developer:Jueyue [email protected]
Excellent Team, undertake project development
Support Spring Boot https://gitee.com/lemur/easypoi-spring-boot-starter
[Official website](http://www.wupaas.com/)
[中文介绍](https://gitee.com/lemur/easypoi/blob/master/README-cn.md)
**The Dev Guide**
**[http://doc.wupaas.com/docs/easypoi/easypoi-1c0u4mo8p4ro8](http://doc.wupaas.com/docs/easypoi/easypoi-1c0u4mo8p4ro8)**
Next steps
- Internationalization, translate documents and code-commenting
- Change all PDF export to Template export
- Synchronise Word tmplate function with the Excel
[User feedback](https://github.com/jueyue/easypoi/issues/2)
Display in order of registration. If you are using Easypoi, please register on https://gitee.com/lemur/easypoi/issues/IFDX7 which is only as a reference for the open source, no other purposes.
- [beyondsoft](http://www.beyondsoft.com)
- [turingoal](http://www.turingoal.com)
- [863soft](http://www.863soft.com/cn/)
- [163](http://www.163.com)
- [towngas](http://www.towngas.com.cn/)
- [weifenghr](https://www.weifenghr.com/)
- [ic-credit](http://sic-credit.cn/)
- [getto1](https://www.getto1.com/)
- [choicesoft](http://www.choicesoft.com.cn/)
- [timeyaa](https://www.timeyaa.com/)
Version introduction
[history.md](https://gitee.com/lemur/easypoi/blob/master/history.md)
Basic demo
[basedemo.md](https://gitee.com/lemur/easypoi/blob/master/basedemo.md)
[Demo project](http://git.oschina.net/lemur/easypoi-test): http://git.oschina.net/lemur/easypoi-test
---------------------------
Advantages of EasyPoi
--------------------------
1.Exquisite Design, easy to use
2.Various Interfaces, easy to extend
3.Coding less do more
4.Support Spring MVC, easy for WEB export
---------------------------
Main Features
--------------------------
For Excel, self-adapt xls and xlsx format. For Word, only docx.
1.Excel Import
- Annotation Import
- Map Import
- Big data Import, sax mode
- Save file
- File validation
- Field validation
2.Excel Export
- Annotation Export
- Template Export
- HTML Export
3.Excel convert to HTML
4.Word Export
5.PDF Export
---------------------------
which methods for which scenarios
---------------------------
- Export
1. Normal excel export (simple format, moderate amount of data, within 50,000)
annotation way: ExcelExportUtil.exportExcel(ExportParams entity, Class<?> pojoClass,Collection<?> dataSet)
2. uncertain columns, but also with simple format and small amount of data
customize way: ExcelExportUtil.exportExcel(ExportParams entity, List<ExcelExportEntity> entityList,Collection<?> dataSet)
3. big data(greater than 50,000, less than one million)
annotation way ExcelExportUtil.exportBigExcel(ExportParams entity, Class<?> pojoClass,IExcelExportServer server, Object queryParams)
customize way: ExcelExportUtil.exportBigExcel(ExportParams entity, List<ExcelExportEntity> excelParams,IExcelExportServer server, Object queryParams)
4. complex style, the amount of data not too large
Template: ExcelExportUtil.exportExcel(TemplateExportParams params, Map<String, Object> map)
5. Export multiple sheets with different styles at one time
Template ExcelExportUtil.exportExcel(Map<Integer, Map<String, Object>> map,TemplateExportParams params)
6. One template but many copies to export
Template ExcelExportUtil.exportExcelClone(Map<Integer, List<Map<String, Object>>> map,TemplateExportParams params)
7. If Template can't satisfy your customization, try HTML
Build your own html, and then convert it to excel: ExcelXorHtmlUtil.htmlToExcel(String html, ExcelType type)
8. Big data(Over millions), please use CSV
annotation way: CsvExportUtil.exportCsv(CsvExportParams params, Class<?> pojoClass, OutputStream outputStream)
customize way: CsvExportUtil.exportCsv(CsvExportParams params, List<ExcelExportEntity> entityList, OutputStream outputStream)
9. Word Export
Template: WordExportUtil.exportWord07(String url, Map<String, Object> map)
10. PDF Export
Template: TODO
- Import
If you want to improve the performance, the concurrentTask of ImportParams will help with concurrent imports;Only support single line, minimum 1000.
For some special reading for single cell, you can use the readSingleCell parameter
1. no need verification, moderate amount of data, within 50,000
annotation or map: ExcelImportUtil.importExcel(File file, Class<?> pojoClass, ImportParams params)
2. the amount of data not too large
annotation or map: ExcelImportUtil.importExcelMore(InputStream inputstream, Class<?> pojoClass, ImportParams params)
3. For big data or with lots of importing operations; Less memory, only support single line
SAX: ExcelImportUtil.importExcelBySax(InputStream inputstream, Class<?> pojoClass, ImportParams params, IReadHandler handler)
4. Big data(Over millions), please use CSV
small data: CsvImportUtil.importCsv(InputStream inputstream, Class<?> pojoClass,CsvImportParams params)
big data: CsvImportUtil.importCsv(InputStream inputstream, Class<?> pojoClass,CsvImportParams params, IReadHandler readHandler)
---------------------------
The difference between XLS and XLSX for Excel Export
---------------------------
1. For export time, XLS is 2-3 times faster than xlsx.
2. For export size, XLS is 2-3 or more times than xlsx.
3. Export need to consider both network speed and local speed.
---------------------------
Packages Guide
---------------------------
1.easypoi -- Parent package
2.easypoi-annotation -- Basic annotation package, action on entity objects,
it's convenient for Maven multi-project management after splitting
3.easypoi-base -- Import and export package, realize Excel Import/Export, Word Export
4.easypoi-web -- Based on AbstractView, Coupled with spring MVC, greatly simplifies the export function
5.sax -- Optional, Export uses xercesImpl, Word Export uses poi-scratchpad
If you don't use spring MVC, only easypoi-base is enough.
--------------------------
maven
--------------------------
https://oss.sonatype.org/content/groups/public/
```xml
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-spring-boot-starter</artifactId>
<version>4.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>4.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>4.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>4.2.0</version>
</dependency>
```
--------------------------
pom
--------------------------
```xml
<!-- sax: optional, using for import -->
<dependency>
<groupId>xerces</groupId>
<artifactId>xercesImpl</artifactId>
<version>${xerces.version}</version>
<optional>true</optional>
</dependency>
<dependency>
<groupId>
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
easypoi工具包 v4.3.0.zip (223个子文件)
deploy.bat 46B
install.bat 36B
.classpath 1KB
.classpath 1KB
.classpath 1KB
excelStyle.css 876B
.gitignore 126B
.gitignore 16B
.gitignore 16B
.gitignore 7B
说明.htm 4KB
easypoi-preview.html 2KB
ExcelExportOfTemplateUtil.java 47KB
ExcelImportService.java 30KB
PoiElUtil.java 25KB
BaseExportService.java 21KB
ExportCommonService.java 19KB
PoiPublicUtil.java 17KB
CellValueService.java 16KB
ExcelExportService.java 15KB
PoiReflectorUtil.java 15KB
CsvImportService.java 14KB
CssParseService.java 13KB
PdfExportServer.java 12KB
ImportBaseService.java 12KB
PoiCssUtils.java 12KB
ParseWord07.java 11KB
HtmlToExcelService.java 11KB
ExcelToHtmlService.java 11KB
PoiWatermarkUtil.java 10KB
ExcelEntityParse.java 10KB
StyleHelper.java 10KB
SheetHandler.java 9KB
ExcelMapParse.java 8KB
PoiMergeCellUtil.java 8KB
PoiWordStyleUtil.java 8KB
MyXWPFDocument.java 8KB
SaxRowRead.java 8KB
ExcelChartBuildService.java 8KB
ExcelExportUtil.java 8KB
ExcelBatchExportService.java 7KB
CsvExportService.java 7KB
Excel.java 7KB
BorderCssConverImpl.java 6KB
PoiFunctionUtil.java 6KB
ExcelImportForkJoinWork.java 6KB
UnicodeInputStream.java 6KB
IEasyPoiWpsService.java 5KB
ExcelImportUtil.java 5KB
CellValueHelper.java 5KB
EasyPoiFileController.java 5KB
PoiZipUtil.java 5KB
MergedRegionHelper.java 5KB
SaxReadExcel.java 4KB
ExportParams.java 4KB
CellStyleBorderEntity.java 4KB
PoiCellUtil.java 4KB
PoiDataDesensitizationUtil.java 4KB
ImportParams.java 4KB
TemplateSumHandler.java 4KB
ExcelExportEntity.java 4KB
ImageCache.java 4KB
TemplateExportParams.java 4KB
PdfExportParams.java 3KB
PoiSheetUtil.java 3KB
ExcelExportStylerColorImpl.java 3KB
PoiExcelTempUtil.java 3KB
CsvImportParams.java 3KB
EasypoiSingleExcelView.java 3KB
EasypoiPDFTemplateView.java 3KB
ExcelExportStylerBorderImpl.java 3KB
ImageEntity.java 3KB
PoiValidationUtil.java 3KB
TextCssConvertImpl.java 3KB
AbstractExcelExportStyler.java 3KB
MapGraphExcelView.java 3KB
EasyPoiWpsUtil.java 3KB
PoiBaseView.java 3KB
ExcelToHtmlParams.java 3KB
CellStyleEntity.java 3KB
FileLoaderImpl.java 3KB
ExcelExportStylerDefaultImpl.java 3KB
HtmlCssConstant.java 3KB
PdfExportUtil.java 3KB
EasypoiTemplateExcelView.java 2KB
ExcelListEntity.java 2KB
EasypoiTemplateWordView.java 2KB
IExcelDataHandler.java 2KB
EasyPoiWpsFileUtil.java 2KB
EasypoiMapExcelView.java 2KB
CsvExportUtil.java 2KB
CssStyleFontEnity.java 2KB
ListParamEntity.java 2KB
ExcelXorHtmlUtil.java 2KB
EasypoiBigExcelExportView.java 2KB
POICacheManager.java 2KB
ExcelCache.java 2KB
WidthCssConverImpl.java 2KB
ExcelForEachParams.java 2KB
MiniAbstractExcelView.java 2KB
共 223 条
- 1
- 2
- 3
资源评论
芝麻粒儿
- 粉丝: 6w+
- 资源: 2万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 部署yolov8的tensorrt模型支持检测分割姿态估计的C++源码+部署步骤.zip
- 以简单、易用、高性能为目标、开源的时序数据库,支持Linux及Windows, Time Series Database.zip
- python-leetcode面试题解之第198题打家劫舍-题解.zip
- python-leetcode面试题解之第191题位1的个数-题解.zip
- python-leetcode面试题解之第186题反转字符串中的单词II-题解.zip
- 一个基于python的web后端高性能开发框架,下载可用
- python-leetcode面试题解之第179题最大数-题解.zip
- python-leetcode面试题解之第170题两数之和III数据结构设计-题解.zip
- python-leetcode面试题解之第168题Excel表列名称-题解.zip
- python-leetcode面试题解之第167题两数之和II输入有序数组-题解.zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功