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();
//构建输出流response.reset();finalString attachmentHeader = "Attachment; Filename*=utf-8''"
+ URLEncoder.encode(PRoject.getName() + ".xls", "UTF-8").replaceAll("\\+", "%20");
response.setHeader("Content-disposition", attachmentHeader);
response.setContentType("application/msExcel");//生成工作表WritableWorkbook wwb =Workbook.createWorkbook(response.getOutputStream());
WritableSheet sheet= wwb.createSheet("任务列表", 1);//格式化文本WritableFont font1 =newWritableFont(WritableFont.TIMES, 12, WritableFont.BOLD);
WritableCellFormat format1=newWritableCellFormat(font1);
format1.setAlignment(jxl.format.Alignment.CENTRE);
format1.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//表格大小sheet.setColumnView(0, 20);//表头sheet.addCell(newLabel(0, 0, "任务名称", format1));//任务列表SimpleDateFormat sdf =newSimpleDateFormat("MM/dd HH:mm");for(inti = 1; i <= taskList.size(); i++) {
ProjectTask pt= taskList.get(i - 1);
sheet.addCell(newLabel(0, i, pt.getName(), format2));
}//关闭输出流wwb.write();
wwb.close();//初始化工作表输出流String title="工程项目导出";
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename="+newString(title.getBytes("GB2312"),"ISO8859_1") +".xls");//标题有中文必须转码 ，attachment：显示另存为对话框inline：尝试用已知关联的程序打开。WritableWorkbook workbook;
OutputStream ouputStream=response.getOutputStream();
workbook=Workbook.createWorkbook(ouputStream);
WritableSheet sheet= workbook.createSheet("工程列表", 0);
sheet.setColumnView(0, 5);//设置宽度jxl.write.WritableFont wfont =newjxl.write.WritableFont(WritableFont.createFont("宋体"), 10);//设置字体WritableCellFormat wc =newWritableCellFormat(wfont);
wc.setAlignment(Alignment.CENTRE);//设置居中wc.setBackground(jxl.format.Colour.LIGHT_GREEN);//设置单元格的背景颜色//工作表内容 - Label labelsheet.addCell(newjxl.write.Label(0, 0,"序号",wc));
sheet.addCell(newjxl.write.Label(13, 0,"任务状态",wc));for(inti = 1; i <= omProjectList.size(); i++) {
OmProject omProject= omProjectList.get(i-1);
sheet.addCell(newjxl.write.Number(0, i,i));
sheet.addCell(newjxl.write.Label(1, i,omProject.getAcceptDate()));
}//关闭工作表输出流workbook.write();
workbook.close();
ouputStream.flush();
ouputStream.close();
FileInputStream inputStream=newFileInputStream(importFile);
FileOutputStream outputStream=newFileOutputStream(filePath);byte[] buf =newbyte[1024];intlength = 0;while((length = inputStream.read(buf)) != -1) {
outputStream.write(buf,0, length);
}
inputStream.close();
outputStream.flush();
Workbook workbook= Workbook.getWorkbook(newFile(filePath));
Sheet[] sheets=workbook.getSheets();if(sheets !=null&& sheets.length > 0) {
Sheet sheet= sheets[0];introwSize =sheet.getRows();for(intj = 1; j < rowSize; j++) {
Cell[] psCells=sheet.getRow(j);
String content=psCells[k].getContents();
}