EXCEL的数据中导入到我自己设定的EXCEL模板中概述.doc

%@?page?language=java?contentType=text/html;?charset=utf-8 ????pageEncoding=utf-8% %@page?import=java.text.SimpleDateFormat% ? %@page?import=org.apache.poi.ss.usermodel.CellStyle% %@page?import=mon.InitApp% %@page?import=com.yinjun.service.ITSBalanceService% %@page?import=com.yinjun.entity.TSBalance% %@page?import=java.util.*% %@page?import=org.apache.poi.ss.usermodel.Cell% %@page?import=org.apache.poi.ss.usermodel.Row% %@page?import=org.apache.poi.ss.usermodel.Sheet% %@page?import=org.apache.poi.hssf.usermodel.HSSFWorkbook% %@page?import=org.apache.poi.ss.usermodel.Workbook% %@page?import=java.io.IOException% %@page?import=java.io.FileInputStream% ? %@page?import=java.io.InputStream% ? ? %@?page?import=java.io.File% %@?page?import=com.yinjun.util.*% % ????request.setCharacterEncoding(utf-8); ????String?msg?=?; ????String?fileName?=?request.getParameter(fileName); ? ????int?index?=?fileName.lastIndexOf(\\); ????if?(index??0)?{ ????????fileName?=?fileName.substring(index?+?1); ????} ? ????String?title?=?new?SimpleDateFormat(yyyyMMdd).format(new?Date()) ????????????+?fileName; ????response.reset(); ????response.setCharacterEncoding(utf-8); ????response.setContentType(application/download); ????response.setHeader(Content-Disposition,?attachment;?filename= ????????????+?new?String(title.getBytes(utf-8),?iso8859-1));//设置文件名显示中文 ????String?startDate?=?request.getParameter(startDate); ????String?endDate?=?request.getParameter(endDate); ????String?meterIds?=?request.getParameter(meterIds); ????String?pageSize?=?request.getParameter(pageSize); ????String?currentPage?=?request.getParameter(currentPage); ????String?statistics?=?request.getParameter(statistics); ????String?exportWay?=?request.getParameter(exportWay); ? ????MapString,?String?map?=?new?HashMapString,?String(); ????map.put(startDate,?startDate); ????map.put(endDate,?endDate); ????map.put(meterIds,?meterIds); ????map.put(currentPage,?currentPage); ????map.put(pageSize,?pageSize); ????if?(all.equals(exportWay))?{ ??