bibinjacob Posted May 2, 2007 Share Posted May 2, 2007 Hi,When i try to export the report(crosstab data) to excel,i get lines(default lines) in back ground as shown in the attached xls(right side and below the data) eventhough iam setting JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND as true.Any idea how to remove the default lines.Please see the attachment.Code i used:JExcelApiExporter exporter = new JExcelApiExporter();exporter.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM, xlsReport);exporter.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);exporter.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.TRUE);exporter.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE,Boolean.TRUE);exporter.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);exporter.setParameter(JExcelApiExporterParameter.IS_FONT_SIZE_FIX_ENABLED,Boolean.TRUE); exporter.exportReport(); regardsbibin jacob [file name=a.xls size=22528]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/a.xls[/file]Post edited by: bibinjacob, at: 2007/05/02 05:02 Link to comment Share on other sites More sharing options...
rafa.ferreira Posted May 30, 2007 Share Posted May 30, 2007 Hy brow!! Sorry about my mediu English.. But you have to eliminate on iReport the spaces between your cells. If you have, for example in your title, have a small line between your title-cell and your top border, the jasper is going to put a cell in THAT place. So for this example put your title-cell with TOP = 0 and left = 0 position. To export to xls is a pain in the balls =P You are going to spend allot of time reorganizing. Any doubt email-me rafa.ferreira@gmail.com []'sRafa Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now