my dog learned polymorphism*
The moose likes Servlets and the fly likes How to Format the Excel sheet in the Servlet .. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "How to Format the Excel sheet in the Servlet .." Watch "How to Format the Excel sheet in the Servlet .." New topic
Author

How to Format the Excel sheet in the Servlet ..

mars76
Ranch Hand

Joined: Nov 30, 2000
Posts: 30
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

Joined: Apr 18, 2001
Posts: 46
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


Vikas Aggarwal<BR>Technology Associate<BR>http://www.vikinsa.com
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to Format the Excel sheet in the Servlet ..