Question

iReport导出Excel报表时为什么不出数据，其他输出格式都能显示数据

private void excelAction(HttpServletRequest request, HttpServletResponse response) throws Exception
{
File jasperfile = new File(request.getSession().getServletContext().getRealPath("/jaspers/report4.jasper"));
JasperReport jasperReport = (JasperReport) JRLoader.loadObject(jasperfile);
File destFile = new File(jasperfile.getParent() + "\\report4.xls");
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap<String, Object>(), conn);
exportExcel(jasperPrint, destFile);
response.sendRedirect("jaspers/report4.xls");
}

private void exportExcel(JasperPrint jasperPrint, File outfile) throws JRException, SQLException {
RXlsxExporter xlsExporter = new JRXlsxExporter();
xlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
xlsExporter.setParameter(JRExporterParameter.OUTPUT_FILE, outfile);
xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS,Boolean.TRUE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED,Boolean.TRUE);
xlsExporter.exportReport();
conn.close();
}

Answer 1

用这个试试
System.out.println("导出excel.........");
response.setContentType("application/vnd.ms-excel");
String filename = null;
if(exportFileName != null && !exportFileName.equals("")){
filename = exportFileName + ".xls";
}else{
filename = DateTime.getSystemDateTimeString() + ".xls";
}
String fileName = new String(filename.getBytes("GBK"),
"ISO8859_1");
response.setHeader("Content-disposition",
"attachment; filename=" + fileName);
JasperReport rep = (JasperReport) JRLoader.loadObject(reportFile);
jasperPrint = JasperFillManager.fillReport(rep, parameters,
conn);
ServletOutputStream ouputStream = response.getOutputStream();
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,ouputStream);
exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);
exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);
exporter.exportReport();
ouputStream.flush();
ouputStream.close();

Answer 2

是什么原因呀？？ 我也遇到这个问题了，十几个报表中，有一个不能导出数据 ，但是单元格已经占用了。就是有几页空页面，但是没有数据。