Hi All.

In Our Project we r using Jasper to generate report in the Xls, we are supposed to use jasperreports-3.5.3 and poi 3.5... but Xls is not generating and even server is not throwing any exception...

Pls help on this..

below is my code snippet



try{
LightDatabaseManager dbManager = new LightDatabaseManager(this);
JasperReport jasperReport = (JasperReport) JRLoader.loadObjectFromLocation(
reportDetail.getFilePath());
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameterMap,
dbManager.getConnection());
exportToFile(reportDetail, jasperPrint);
}
catch(Exception e){
e.printStackTrace();
logger.error("XXXXXXXXXXXX"+e);
}




private void exportToFile(NBReportConfigLEnum reportDetail, JasperPrint jasperPrint)
throws JRException{
logger.debug("...................................I nside exportToFile.............");
try{
ByteArrayOutputStream baos = new ByteArrayOutputStream();
switch(reportDetail.getFileResponse()){
case PDF:
JasperExportManager.exportReportToPdfStream(jasper Print, baos);
servletResponse.setContentLength(baos.size());
setInputStream(new ByteArrayInputStream(baos.toByteArray()));
break;
case XLS:
logger.debug(".....Inside XLS......");
JRXlsExporter exporterXLS = new JRXlsExporter();
logger.debug(".....exporterXLS......"+exporterXLS) ;
exporterXLS.setParameter(JRXlsExporterParameter.JA SPER_PRINT, jasperPrint);
logger.debug(".....After JASPER_PRINT......");
exporterXLS.setParameter(JRXlsExporterParameter.OU TPUT_STREAM, baos);
logger.debug(".....After OUTPUT_STREAM......");
exporterXLS.setParameter(JRXlsExporterParameter.IS _ONE_PAGE_PER_SHEET,
Boolean.FALSE);
logger.debug(".....After IS_ONE_PAGE_PER_SHEET......");
exporterXLS.setParameter(JRXlsExporterParameter.IS _DETECT_CELL_TYPE,
Boolean.TRUE);
logger.debug(".....After IS_DETECT_CELL_TYPE......");
exporterXLS.setParameter(JRXlsExporterParameter.IS _WHITE_PAGE_BACKGROUND,
Boolean.FALSE);
logger.debug(".....After IS_WHITE_PAGE_BACKGROUND......");
exporterXLS.setParameter(JRXlsExporterParameter.IS _REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
Boolean.TRUE);
logger.debug(".....After IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS......");

try {
logger.debug(".....Inside exportReport block......");
exporterXLS.exportReport(); logger.debug(".....After exportReport......");
}catch(Exception ex) {
logger.error("Exception in exportReport() ::: "+ex);
ex.printStackTrace();
}

try {
servletResponse.setContentLength(baos.size());
servletResponse.setContentType("application/vnd.ms-excel");
setInputStream(new ByteArrayInputStream(baos.toByteArray()));
}catch(Exception ex) {
logger.error("Exception when setting servletResponce in exportToFile() :::"+ex);
ex.printStackTrace();
}
break;
default:
break;
}
}
catch(Exception e){
e.printStackTrace();

}
}
}


exporterXLS.exportReport() is invoking but it's not throwing any exception and not generating any Xls..