psh686868/excel-plus

Easier to read and generate an excel file, supports 2003 and 2007.

excel-plus

Easier to read and generate an excel file, supports 2003 and 2007.

Feature

• Easy to use
• Annotation driven
• Based java 8
• Support xls、xlsx、csv

Usage

Add maven dependency

<dependency>
    <groupId>io.github.biezhi</groupId>
    <artifactId>excel-plus</artifactId>
    <version>0.0.1</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();
List<Order>  orders = excelPlus.readAsFile(new File("/Users/biezhi/Desktop/order.xls"), Order.class);

Read as stream

ExcelPlus excelPlus = new ExcelPlus();
List<Order>  orders = excelPlus.readAsStream(inputStream, Order.class);

Examples

See here

Advanced

Custom export style

License

Apache2