I guess the problem is with the API you are using . Try using JExcelAPI your problem will be resolved. Code:JExcelApiExporter excelApiExporter = new JExcelApiExporter(); excelApiExporter.setParameter(JRExporterParameter.JASPER_PRINT, jPrint); excelApiExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,outputdirectory + reportName + ".xls"); excelApiExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); excelApiExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE); excelApiExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS,Boolean.TRUE); excelApiExporter.exportReport(); Post Edited by prani_vel at 07/19/2010 07:32