excel cell format with 2 decimal point
843841Aug 6 2004 — edited Aug 6 2004Hi, 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