使用IE10中不工作的Java导出到excel
我在IE10中打开excel表格时遇到问题。在我的项目中,我将在选择特定部门后生成一份报告,当我单击“打开”打开报告时,它将以excel格式打开,名称为ConstraintReport。xls。当我点击另一个部门并给出生成报告时,它应该以ConstarintReport(1)的名义打开。xls。但它会抛出一个错误,声明“无法打开两个同名文件”。能做些什么
if(mode != null && mode.equalsIgnoreCase(TLOConstants.REPORT_CONTROL)){
List controlList = getReportService().getControlReportList(reportsVO);
if(controlList.size()!=0){
resultArray1 = controlReportFormatList(controlList);
byteArrayStream = WorkbookUtil.generateControlPlanReport(resultArray1);
excelSheet = TLOConstants.CONTROL_REPORT;
openExcel = true;
}
}
if(openExcel==true){
response.setHeader(TLOConstants.CACHE_CTRL, TLOConstants.PUBLIC);
response.setHeader(TLOConstants.PRAGMA, TLOConstants.PUBLIC);
response.setHeader(TLOConstants.EXPIRES,TLOConstants.ZERO);
response.setHeader(TLOConstants.CONTENT_DISPOSITION, TLOConstants.ATTACH_FILE_NAME + excelSheet + ".xls\";");
response.setContentType(TLOConstants.APPLICATION_VNDMS_XLS);
if (byteArrayStream != null) {
response.getOutputStream().write(byteArrayStream.toByteArray());
}
response.getOutputStream().flush();
byteArrayStream.close();
logMethodExit(TLOConstants.ON_SUBMIT);
return null;
共 (0) 个答案