国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 學(xué)院 > 開發(fā)設(shè)計(jì) > 正文

java處理Excel相關(guān)筆記

2019-11-14 15:00:26
字體:
供稿:網(wǎng)友
           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();      }

 


發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 湾仔区| 西平县| 石景山区| 华亭县| 南平市| 大丰市| 买车| 舟山市| 五台县| 舟曲县| 台东县| 德庆县| 青川县| 广州市| 吴川市| 紫阳县| 江达县| 东乡县| 安福县| 河东区| 新竹市| 永修县| 泰和县| 丹巴县| 平乡县| 秦皇岛市| 濮阳市| 星座| 博乐市| 祁阳县| 射洪县| 慈利县| 措勤县| 揭西县| 奇台县| 洪江市| 浠水县| 韶山市| 苍南县| 京山县| 威信县|