• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Report generated in excel.

 
Akshay Singhvi
Ranch Hand
Posts: 93
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
jenita brown
Ranch Hand
Posts: 51
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1824
Eclipse IDE Java Ruby
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic