aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Report generated in excel.  " Watch "Report generated in excel.  " New topic
Author

Report generated in excel.

Akshay Singhvi
Ranch Hand

Joined: Nov 08, 2005
Posts: 93
Folks,
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
Bartender

Joined: Aug 20, 2001
Posts: 1821

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.