Easier to read and generate an excel file, supports 2003 and 2007.
- Easy to use
- Annotation driven
- Based java 8
- Support
xls
、xlsx
、csv
- Support export by template
- Support custom column style
As maven dependency
<dependency>
<groupId>io.github.biezhi</groupId>
<artifactId>excel-plus</artifactId>
<version>0.1.2-RELEASE</version>
</dependency>
snapshot version
<dependency>
<groupId>io.github.biezhi</groupId>
<artifactId>excel-plus</artifactId>
<version>0.1.3-SNAPSHOT</version>
</dependency>
Export as file
ExcelPlus excelPlus = new ExcelPlus();
List<Order> orders = queryData();
excelPlus.exportor(orders).writeAsFile(new File("order-list.xls"));
Browser download
ExcelPlus excelPlus = new ExcelPlus();
List<Order> orders = queryData();
excelPlus.exportor(orders)
.writeAsResponse(ResponseWrapper.create(HttpServletResponse, "order-list.xls"));
Read as file
ExcelPlus excelPlus = new ExcelPlus();
Reader reader = Reader.create()
.parseType(ParseType.SAX)
.startRowIndex(2)
.sheetIndex(0)
.excelFile(new File("orders.xlsx"));
List<Order> orders = excelPlus.read(Order.class, reader).asList();
See here
Custom export style