Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

excel cell format with 2 decimal point

843841Aug 6 2004 — edited Aug 6 2004
Hi, I am writing a servlet and its output is a tab demimited text which need to be displayed in MS Excel spreadsheet. For which I am using response.setContentType("application/vnd.ms-excel");
e.g.
aaa '\t' $5.00 '\t' 4.00 '\n'
bbbbbb '\t' $3.00 '\t' 3.00 '\n'
ccc \t' $10.00 '\t' 1.00 '\n'


Everything seems perfect except the third column display as integer without decimal points. Is there any way I can set the cell format after I set the content type of ServletResponse? I need the output with deciamal points.

Appreciate your help.

JassiS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2004
Added on Aug 6 2004
4 comments
227 views