wood burning stoves 2.0
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
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.
wood burning stoves
subject: Report generated in excel.
It's not a secret anymore!