String name = file.getFilename(); name = name.replaceAll("(&|=|,)", ""); response.setHeader("Content-Disposition", "Attachment; Filename=" + name); response.setContentType(file.getContentType()); IOUtils.copy(file.getInputStream(), response.getOutputStream()); response.flushBuffer();
// 構(gòu)建輸出流 response.reset(); final String attachmentHeader = "Attachment; Filename*=utf-8''" + URLEncoder.encode(PRoject.getName() + ".xls", "UTF-8").replaceAll("http://+", "%20"); response.setHeader("Content-disposition", attachmentHeader); response.setContentType("application/msExcel"); // 生成工作表 WritableWorkbook wwb = Workbook.createWorkbook(response.getOutputStream()); WritableSheet sheet = wwb.createSheet("任務(wù)列表", 1); // 格式化文本 WritableFont font1 = new WritableFont(WritableFont.TIMES, 12, WritableFont.BOLD); WritableCellFormat format1 = new WritableCellFormat(font1); format1.setAlignment(jxl.format.Alignment.CENTRE); format1.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE); // 表格大小 sheet.setColumnView(0, 20); // 表頭 sheet.addCell(new Label(0, 0, "任務(wù)名稱", format1)); // 任務(wù)列表 SimpleDateFormat sdf = new SimpleDateFormat("MM/dd HH:mm"); for (int i = 1; i <= taskList.size(); i++) { ProjectTask pt = taskList.get(i - 1); sheet.addCell(new Label(0, i, pt.getName(), format2)); } // 關(guān)閉輸出流 wwb.write(); wwb.close(); //初始化工作表輸出流 String title="工程項(xiàng)目導(dǎo)出"; response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-disposition", "attachment;filename="+new String(title.getBytes("GB2312"),"ISO8859_1") +".xls"); //標(biāo)題有中文必須轉(zhuǎn)碼 ,attachment:顯示另存為對(duì)話框inline:嘗試用已知關(guān)聯(lián)的程序打開。 WritableWorkbook workbook; OutputStream ouputStream = response.getOutputStream(); workbook = Workbook.createWorkbook(ouputStream); WritableSheet sheet = workbook.createSheet("工程列表", 0); sheet.setColumnView(0, 5); //設(shè)置寬度 jxl.write.WritableFont wfont = new jxl.write.WritableFont(WritableFont.createFont("宋體"), 10);//設(shè)置字體 WritableCellFormat wc = new WritableCellFormat(wfont); wc.setAlignment(Alignment.CENTRE); // 設(shè)置居中 wc.setBackground(jxl.format.Colour.LIGHT_GREEN); // 設(shè)置單元格的背景顏色 //工作表內(nèi)容 - Label label sheet.addCell(new jxl.write.Label(0, 0,"序號(hào)",wc)); sheet.addCell(new jxl.write.Label(13, 0,"任務(wù)狀態(tài)",wc)); for (int i = 1; i <= omProjectList.size(); i++) { OmProject omProject = omProjectList.get(i-1); sheet.addCell(new jxl.write.Number(0, i,i)); sheet.addCell(new jxl.write.Label(1, i,omProject.getAcceptDate())); } //關(guān)閉工作表輸出流 workbook.write(); workbook.close(); ouputStream.flush(); ouputStream.close(); FileInputStream inputStream = new FileInputStream(importFile); FileOutputStream outputStream = new FileOutputStream(filePath); byte[] buf = new byte[1024]; int length = 0; while ((length = inputStream.read(buf)) != -1) { outputStream.write(buf, 0, length); } inputStream.close(); outputStream.flush(); Workbook workbook = Workbook.getWorkbook(new File(filePath)); Sheet[] sheets = workbook.getSheets(); if (sheets != null && sheets.length > 0) { Sheet sheet = sheets[0]; int rowSize = sheet.getRows(); for (int j = 1; j < rowSize; j++) { Cell[] psCells = sheet.getRow(j); String content = psCells[k].getContents(); }
新聞熱點(diǎn)
疑難解答
圖片精選
網(wǎng)友關(guān)注