How to Format the Excel sheet in the Servlet ..

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

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