《将excel数据导入excel模板》由会员分享,可在线阅读,更多相关《将excel数据导入excel模板(7页珍藏版)》请在金锄头文库上搜索。
1、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 Strin
2、g(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(“cur
3、rentPage“);String statistics = request.getParameter(“statistics“);String exportWay = request.getParameter(“exportWay“);Map map = new HashMap();map.put(“startDate“, startDate);map.put(“endDate“, endDate);map.put(“meterIds“, meterIds);map.put(“currentPage“, currentPage);map.put(“pageSize“, pageSize);i
4、f (“all“.equals(exportWay) map.put(“queryAll“, “queryAll“);/选择查询全部map.put(“statistics“, statistics);ITSBalanceService tsbalanceService = (ITSBalanceService) InitApp.context.getBean(“tsbalanceService“);Map data = tsbalanceService.showTSBalance(map);List projectNodeList = (List) data.get(“tsbalanceLis
5、t“);String path = request.getRealPath(“/excelTemplate“).replace(“,“/“);String filePath = path + “/“ + fileName;File file = new File(filePath);InputStream is = null;try is = new FileInputStream(file);Workbook wb = new HSSFWorkbook(is);int sheetsNum = wb.getNumberOfSheets();/找到对应的 sheetfor (int i = 0; i