Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to Format the Excel sheet in the Servlet ..

 
mars76
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I am generating a report in a servlet and sending the report to the Browser in an Excel sheet format. Now how can we format the cells in the Excel sheet. For Example if we want to freeze one column(which can be done in Excel) in the report we are generating then how to get control over the Formatting...
Shall we need to know the File Formatting of the Excel...
pls suggest some good links ....
Thanks in advance..
Sateesh
 
vikinsa
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are trying to export an HTML to excel please try to design your html as simple as possible with the least use of HTML specific things like nested tables etc. If you can do that there will be no problem at all. I have tried it yesterday.

Originally posted by sateesh kommineni:
Hi
I am generating a report in a servlet and sending the report to the Browser in an Excel sheet format. Now how can we format the cells in the Excel sheet. For Example if we want to freeze one column(which can be done in Excel) in the report we are generating then how to get control over the Formatting...
Shall we need to know the File Formatting of the Excel...
pls suggest some good links ....
Thanks in advance..
Sateesh


------------------
Vikas Aggarwal
Technology Associate
http://www.vikinsa.com
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic