Jump to content
We've recently updated our Privacy Statement, available here ×

Web reports in xls format look bad


wbizzare

Recommended Posts

I export reports to excel on the web by redirecting the request to the servlet net.sf.jasperreports.j2ee.servlets.XlsServlet. However, the results are not good enough to deliver to my users. I am currently providing export of pdf, rtf, and html which look great. They want EXCEL output but not like this. The EXCEL result has lots of created row and column lines that are added for alignment and also lots of extra artifacts between cells. What the user wants when they select EXCEL is primarily data extraction.

 

How can this be cleaned up so that the result looks more like the other output types?

 

Note: By redirecting the request, I cannot set parameters used by the exporter because it is instantiated in the redirected servlet. If I could set response parameters that would be picked up by the servlet that would help - like being able to remove extra rows.

 

When I try to implement the EXCEL exporter in my servlet it fails for a variety of reasons.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...