normalexcelconstants导出怎么设置底部

之前使用poi导出Excel表格，需要配置很多东西，也比较麻烦，这里使用poi的封装easypoi，可以快速配置，实现Excel或者word文件的导出。这里我们结合SpringMVC开发easypoi。
导入jar包
这里是springMVC和easypoi所需的jar包
主要是easypoi-base和easypoi-web，其它都是关联所需的jar包，我们需要commons-lang3jar包，开始使用commons-lang26版本会出现错误。
spring-servletxml配置
[html] view plain copy
<!-- Bean解析器,级别高于默认解析器,寻找bean对象进行二次处理 -->
<bean id="beanNameViewResolver"
class="orgspringframeworkwebservletviewBeanNameViewResolver" p:order="0">
</bean>
[html] view plain copy
<!-- Excel 处理 根据用户输入进行对象处理 -->
<bean id="jeecgExcelView" class="orgjeecgframeworkpoiexcelviewJeecgSingleExcelView" />
<bean id="jeecgTemplateExcelView" class="orgjeecgframeworkpoiexcelviewJeecgTemplateExcelView" />
<bean id="jeecgTemplateWordView" class="orgjeecgframeworkpoiexcelviewJeecgTemplateWordView" />
<bean id="jeecgMapExcelView" class="orgjeecgframeworkpoiexcelviewJeecgMapExcelView" />
controller
[java] view plain copy
package commvccontroller;

import javautilArrayList;
import javautilHashMap;
import javautilList;
import javautilMap;

import javaxservlethttpHttpServletRequest;
import javaxservlethttpHttpServletResponse;

import orgjeecgframeworkpoiexcelentityExportParams;
import orgjeecgframeworkpoiexcelentityparamsExcelExportEntity;
import orgjeecgframeworkpoiexcelentityvoMapExcelConstants;
import orgjeecgframeworkpoiexcelentityvoNormalExcelConstants;
import orgspringframeworkstereotypeController;
import orgspringframeworkuiModelMap;
import orgspringframeworkwebbindannotationRequestMapping;
import orgspringframeworkwebbindannotationRequestMethod;

@Controller
@RequestMapping(value="/excel")
public class ExcelController {

/

方法名：
开发者：
开发时间：2016-12-29
/
@RequestMapping(value = "/export",method = {RequestMethodPOST,RequestMethodGET})
public String export(HttpServletRequest request,HttpServletResponse response,ModelMap modelMap){
//标题
List<ExcelExportEntity> entityList = new ArrayList<ExcelExportEntity>();
//内容
List<Map<String,Object>> dataResult = new ArrayList<Map<String,Object>>();
entityListadd(new ExcelExportEntity("表头1", "table1", 15));
entityListadd(new ExcelExportEntity("表头2", "table2", 25));
entityListadd(new ExcelExportEntity("表头3", "table3", 35));
for (int i = 0; i < 10; i++) {
Map<String, Object> map = new HashMap<String, Object>();
mapput("table1", "苹果"+i);
mapput("table2", "香蕉"+i);
mapput("table3", "鸭梨"+i);
dataResultadd(map);
}
modelMapput(MapExcelConstantsENTITY_LIST, entityList);
modelMapput(MapExcelConstantsMAP_LIST, dataResult);
String fileName = "easypoi测试列表";
modelMapput(MapExcelConstantsFILE_NAME, fileName);
modelMapput(NormalExcelConstantsPARAMS, new ExportParams("easypoi列表", "测试列表"));
return MapExcelConstantsJEECG_MAP_EXCEL_VIEW;
}

}
配置好表头，内容体，文件名就可以使用了

以上就是关于normalexcelconstants导出怎么设置底部全部的内容，包括:normalexcelconstants导出怎么设置底部、、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！