1 将設定好格式的excel另存為xml
2 放到項目中,我的在
3 擷取資料
@RequestMapping("/exportModel.dox")
public void ExportModel(HttpServletRequest request, HttpServletResponse response, String startTime,String endTime ) throws Exception {
//資料擷取
StatisticsModelExport exp = new StatisticsModelExport();
Map<String, Map<String, Map<String, String>>> data = exp.modelSheet(dataAnalysisServiceImpl, startTime, endTime);
String dateStr = new SimpleDateFormat("MMdd").format(Calendar.getInstance().getTime());
String fileName = "模闆導出-" + dateStr + ".xls";
// 導出
request.setCharacterEncoding("UTF-8");
response.setContentType("application/x-download;");
response.setHeader("Content-disposition", "attachment; filename="
+ new String(fileName.getBytes("gb2312"), "ISO8859-1"));
Configuration config = new Configuration();
//指定預設編碼格式
config.setDefaultEncoding("UTF-8");
//設定模版檔案的路徑
config.setClassForTemplateLoading(DataGroupAggsController.class, "/");
//獲得模版包
Template template = config.getTemplate("model.xml");
//定義輸出流,注意必須指定編碼
Writer writer = new BufferedWriter(new OutputStreamWriter(response.getOutputStream(), "UTF-8"));
try {
template.process(data, writer);
} catch (TemplateException e) {
e.printStackTrace();
}
}
4 資料填充
用excel打開model.xml檔案(還是剛剛放到項目中的那個xml檔案),将表達式填充到單元格中(由于我的sheet也比較多,每個sheet也又包含多個表格,是以我的結構是比較複雜的三重map結構)
我的map格式如下所示
5 将填充了表達式的xml檔案替換項目中的模闆
6 結束