Jeecg-easypoi-2.0.3 release

Easypoi is developed independently based on the poi module of jeecg. It can be said that it is version 2.0. The purpose of easypoi encapsulation is the same as that of jeecg, and we strive to make everyone write less do more, in this way, easypoi allows you to import and export Excel files without writing code, export Excel templates (make beautiful Excel files), and export Word templates, this frees everyone from complicated poi interfaces and completes their work more quickly.

Easypoi features

?Annotation is the basis for everyone to know

?Annotation is the core for quick development.

?A simple export and import interface can be completed quickly

?Simple data interfaces and Custom Data

?Excel template, beautifying excel, program one day, excel1 minute

?Word template, a powerful artifact of notification files

?Springview Integration

 

Easypoi hopes to help you solve the problem (this is also a problem that the author has encountered). easypoi cannot help you solve the 100% Excel import and export problem, however, at least 60% of data can be imported and exported without increasing the amount of code.

Main problems solved:

? Lower the development threshold

? Shorten the development cycle

? Beautify statistical reports

? Easy document Export

EasypoiVersion Information

Version: 2.0.3

Author: jueyue)

Email: [email protected]

Community: jeecg community (http://www.jeecg.org /)

 

Modify logs

1. comprehensive update of annotations

2. The new data processing interface replaces the conversion function.

3. Add exception information

4. Add cache Processing

5. The table Styler can cover

6. added spring view for Excel and Word.

 

 

Bug Modification

1. Support for Data Import

2. Single Row data in the header

3. Data Extraction from an Excel template

 

Sample Code

/** Student name */
@ Excel (name = "Student name ")
Privatejava. Lang. stringname;
/** Student gender */
@ Excel (name = "", replace = {" _ 1", "_ 0 "})
Privatejava. Lang. stringsex;


@ Excel (name = "Date of Birth", exportformat = "yyyy-mm-DDHH: mm: SS", importformat = "yyyy-mm-DDHH: mm: SS ")
Private date birthday;
Excel Export
List <courseentity> courses = This. courseservice. getlistbycriteriaquery (CQ, false );


Map. Put (normalexcelconstants. file_name, "user information ");
Map. Put (normalexcelconstants. Class, courseentity. Class );
Map. Put (normalexcelconstants. Params, newexportparams ("course list", "exported by: jeecg ",
"Export information "));
Map. Put (normalexcelconstants. data_list, courses );
Returnnormalexcelconstants. jeecg_excel_view;

Excel template Export
Modelmap. Put (templateexcelconstants. file_name, "wage statistics ");
Modelmap. Put (templateexcelconstants. Params, newtemplateexportparams ("Export/template/exporttemp.xls", 1 ));
Modelmap. Put (templateexcelconstants. map_data, MAP );
Returntemplateexcelconstants. jeecg_template_excel_view;

Word export example

Modelmap. Put (templateexcelconstants.File_name, "Course information ");

Modelmap. Put (templateexcelconstants.Params,NewTemplateexportparams ("Export/template/exporttemp.xls "));

Modelmap. Put (templateexcelconstants.Map_data, MAP );

Modelmap. Put (templateexcelconstants.Class, Courseentity.Class);

Modelmap. Put (templateexcelconstants.List_data, Courses );

ReturnTemplateexcelconstants.Jeecg_template_excel_view;

Jeecg-easypoi-2.0.3 release