I have written a web application which generates excel data using table tag in html.
As you can see 123.00 is a floating point value. But in excel it is displayed as 123 instead of 123.00. I need to fix this.
Thanks
Lester Burnham
Rancher
Joined: Oct 14, 2008
Posts: 1337
posted
0
If you need precise control over this, then you need to generate an actual Excel file (using a library like Apache POI or jExcelApi). While Excel can import HTML tables it's kind of a hack not meant for serious work.