File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes Report generated in excel.  Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Report generated in excel.  " Watch "Report generated in excel.  " New topic

Report generated in excel.

Akshay Singhvi
Ranch Hand

Joined: Nov 08, 2005
Posts: 93
I'm using iReport to generating the jasper file, which i am using it in my project to generate report in Excel sheet.
Now the point of concern is that when the report is generated in Excel, it starts from 2 row leaving the first row blank.
how can I remove the blank first row from the excel sheet, do i need to make some change in the jrxml file to cater this.

Regards,<br />Akshay Singhvi<br />SCJP 1.4 (95%)<br />SCWCD 1.4 (86%)
jenita brown
Ranch Hand

Joined: Feb 20, 2007
Posts: 51
hi Akshay,

Did you get a solution to this problem of yours? I am facing a similar problem with the excel sheet leaving a cell in between and printing on alternate cells.Could you or any other rancher help me out with this issue?
Joel McNary

Joined: Aug 20, 2001
Posts: 1824

Try removing any page headers/footers that you might have. Also, line your fields up so that the top is at 0 (not 3 or 5 or 18 or whatever it might be)

Also, read this from the JasperReports FAQ on how to make CSV-friendly reports.

Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
I agree. Here's the link:
subject: Report generated in excel.
It's not a secret anymore!