neo_lestat

Hi, I was searching for put the cell borders in excel whit jasperreport and I found it, I looked the api, you have tu pass some properties to jasperreport, I'm using this: String reportSource = "report.jasper"; HashMap parameters= new HashMap(); parameters.put(JRParameter.IS_IGNORE_PAGINATION, true); JasperReport jasperReport = (JasperReport) JRLoader.loadObject(reportSource); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, connection); JExcelApiExporter exporter = new JExcelApiExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, tempFile); exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, false); exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, true); // These are the parameters, the first is to put the border cell and the second is to disable de background exporter.setParameter(JRXlsExporterParameter.IS_IGNORE_CELL_BORDER, false); exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, false); exporter.exportReport(); I'm using jasperreport 3, good luck !!!/tools/fckeditor/editor/images/smiley/msn/thumbs_up.gif

The arial font is not insalled in mi linux machine. I installed it and works fine, thank you very much

The field where is the problem is INTERPRETACION, it has codification Cp1252,