File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes HTML, CSS and JavaScript and the fly likes Application Generates excel Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Reply Bookmark "Application Generates excel " Watch "Application Generates excel " New topic
Author

Application Generates excel

Jagdeep Sharma
Ranch Hand

Joined: May 24, 2010
Posts: 121

Guys,

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
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.
 
 
subject: Application Generates excel
 
Threads others viewed
Problem in exporting the jsp in excel
Easy way to parse HTTP response
html table to excel problem
import HTML rows to Excel
very very low performance while exporting large amount of data to excel
IntelliJ Java IDE