@ExcelTarget("courseEntity")
public class CourseEntity implements java.io.Serializable {
    /** Primary Key */
    private String id;
    /** Course Name */
    @Excel(name = "Course Name", orderNum = "1", needMerge = true)
    private String name;
    /** Teacher */
    @ExcelEntity(id = "yuwen")
    @ExcelVerify()
    private TeacherEntity teacher;
    /** Math Teacher */
    @ExcelEntity(id = "shuxue")
    private TeacherEntity shuxueteacher;

    @ExcelCollection(name = "Students", orderNum = "4")
    private List<StudentEntity> students;
}

HSSFWorkbook workbook = ExcelExportUtil.exportExcel(new ExportParams(
    "2412312", "Test", "Test"), CourseEntity.class, list);

ExportParams params = new ExportParams("2412312", "Test", "Test");
params.setAddIndex(true);
HSSFWorkbook workbook = ExcelExportUtil.exportExcel(params,
    TeacherEntity.class, telist);

List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
entity.add(new ExcelExportEntity("Name", "name"));
entity.add(new ExcelExportEntity("Gender", "sex"));

List<Map<String, String>> list = new ArrayList<Map<String, String>>();
Map<String, String> map;
for (int i = 0; i < 10; i++) {
    map = new HashMap<String, String>();
    map.put("name", "1" + i);
    map.put("sex", "2" + i);
    list.add(map);
}

HSSFWorkbook workbook = ExcelExportUtil.exportExcel(new ExportParams(
    "Test", "Test"), entity, list);

TemplateExportParams params = new TemplateExportParams();
params.setHeadingRows(2);
params.setHeadingStartRow(2);
Map<String,Object> map = new HashMap<String, Object>();
map.put("year", "2013");
map.put("sunCourses", list.size());
Map<String,Object> obj = new HashMap<String, Object>();
map.put("obj", obj);
obj.put("name", list.size());
params.setTemplateUrl("org/jeecgframework/poi/excel/doc/exportTemp.xls");
Workbook book = ExcelExportUtil.exportExcel(params, CourseEntity.class, list, map);

ImportParams params = new ImportParams();
params.setTitleRows(2);
params.setHeadRows(2);
//params.setSheetNum(9);
params.setNeedSave(true);
long start = new Date().getTime();
List<CourseEntity> list = ExcelImportUtil.importExcel(new File(
    "d:/tt.xls"), CourseEntity.class, params);

@RequestMapping(value = "/exportXls")
public ModelAndView exportXls(HttpServletRequest request, HttpServletResponse response) {
    ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
    List<JeecgDemo> pageList = jeecgDemoService.list();
    // Export file name
    mv.addObject(NormalExcelConstants.FILE_NAME, "Export Excel File Name");
    // Annotated object Class
    mv.addObject(NormalExcelConstants.CLASS, JeecgDemo.class);
    // Custom table parameters
    mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("Custom Export Excel Title", "Custom Sheet Name"));
    // Export data list
    mv.addObject(NormalExcelConstants.DATA_LIST, pageList);
    return mv;
}

/**
 * Email validation
 */
@Excel(name = "Email", width = 25)
@ExcelVerify(isEmail = true, notNull = true)
private String email;

/**
 * Mobile phone validation
 */
@Excel(name = "Mobile", width = 20)
@ExcelVerify(isMobile = true, notNull = true)
private String mobile;

ExcelImportResult<ExcelVerifyEntity> result = ExcelImportUtil.importExcelVerify(
    new File("d:/tt.xls"), ExcelVerifyEntity.class, params);
for (int i = 0; i < result.getList().size(); i++) {
    System.out.println(ReflectionToStringBuilder.toString(result.getList().get(i)));
}

ImportParams params = new ImportParams();
List<Map<String,Object>> list = ExcelImportUtil.importExcel(new File(
    "d:/tt.xls"), Map.class, params);

@Excel(name="Gender", width=15, dicCode="sex")
private java.lang.String sex;

@Excel(name="Department", dictTable="t_s_depart", dicCode="id", dicText="departname")
private java.lang.String depart;

@Excel(name="Test Replace", width=15, replace={"Male_1","Female_0"})
private java.lang.String fdReplace;

@Excel(name="Test Convert", width=15, exportConvert=true, importConvert=true)
private java.lang.String fdConvert;

/**
 * Conversion example: Add suffix to the field value
 * @return
 */
public String convertgetFdConvert(){
    return this.fdConvert + " Yuan";
}

/**
 * Conversion example: Replace "Yuan" in Excel cell
 * @return
 */
public void convertsetFdConvert(String fdConvert){
    this.fdConvert = fdConvert.replace(" Yuan", "");
}

public class SysUser implements Serializable {

    /** id */
    private String id;

    /** Login Account */
    @Excel(name = "Login Account", width = 15)
    private String username;

    /** Real Name */
    @Excel(name = "Real Name", width = 15)
    private String realname;

    /** Avatar */
    @Excel(name = "Avatar", width = 15)
    private String avatar;

    /** Birthday */
    @Excel(name = "Birthday", width = 15, format = "yyyy-MM-dd")
    private Date birthday;

    /** Gender (1: Male 2: Female) */
    @Excel(name = "Gender", width = 15, dicCode="sex")
    private Integer sex;

    /** Email */
    @Excel(name = "Email", width = 15)
    private String email;

    /** Phone */
    @Excel(name = "Phone", width = 15)
    private String phone;

    /** Status (1: Normal 2: Frozen) */
    @Excel(name = "Status", width = 15, replace={"Normal_1","Frozen_0"})
    private Integer status;
}

@Data
public class JeecgOrderMainPage {
    
    /** Primary Key */
    private java.lang.String id;
    
    /** Order Number */
    @Excel(name="Order Number", width=15)
    private java.lang.String orderCode;
    
    /** Order Type */
    private java.lang.String ctype;
    
    /** Order Date */
    @Excel(name="Order Date", width=15, format = "yyyy-MM-dd")
    private java.util.Date orderDate;
    
    /** Order Amount */
    @Excel(name="Order Amount", width=15)
    private java.lang.Double orderMoney;
    
    /** Order Note */
    private java.lang.String content;
    
    /** Created By */
    private java.lang.String createBy;
    
    /** Create Time */
    private java.util.Date createTime;
    
    /** Updated By */
    private java.lang.String updateBy;
    
    /** Update Time */
    private java.util.Date updateTime;
    
    @ExcelCollection(name="Customer")
    private List<JeecgOrderCustomer> jeecgOrderCustomerList;
    
    @ExcelCollection(name="Ticket")
    private List<JeecgOrderTicket> jeecgOrderTicketList;
}