<!-- 初始化SpringUtil -->
<bean id="springUtil" class="org.easy.util.SpringUtil"/>

<!-- 测试使用 ,学生类-->
<excel id="student" class="org.easy.excel.test.model.StudentModel" enableStyle="true">
	<field name="id" align="center" titleBgColor="dark_blue"
	columnWidth="3000" titleFountColor="white" title="ID" uniformStyle="true"/>
	<field name="name" title="学生姓名" align="right"/>
	<field name="age" title="年龄" align="center" titleFountColor="red" titleBgColor="dark_blue" isNull="false" regex="^[1-9]\d*$" regexErrMsg="必须是数字"/>
	<field name="studentNo" title="学号" titleFountColor="blue" isNull="false" />
	<field name="createTime" columnWidth="4000" title="创建时间" pattern="yyyy-MM-dd"/>
	<field name="status" title="状态" titleBgColor="green" format="1:正常,0:禁用,-1:无效" />
	<!-- 创建人,可能需要查询数据库校验,这里使用自定义解析器 -->
	<field name="createUser" title="创建人" 
	cellValueConverter="org.easy.excel.test.converter.CreateUserCellValueConverter"/>
	
	<!-- 复杂对象 -->
	<field name="book.bookName" title="图书名称" columnWidth="6000"/>
	<field name="book.author.authorName" title="作者名称"/>
</excel>

public void testImport()throws Exception{
	InputStream fis = new FileInputStream(path);
	ExcelImportResult result = context.readExcel(excelId, fis);
	System.out.println(result.getHeader());
	List<StudentModel> stus = result.getListBean();
	for(StudentModel stu:stus){
		System.out.println(stu);
		BookModel book = stu.getBook();
		System.out.println(book);
		if(book!=null){
			System.out.println(book.getAuthor());
		}
	}
}

public void testExportSimple()throws Exception{
	OutputStream ops = new FileOutputStream(path);
	Workbook workbook = context.createExcel(excelId,getStudents());
	workbook.write(ops);
	ops.close();
	workbook.close();
}