This week's book / license giveaways are in the JDBC and Relational Databases and Java in General forums.
We're giving away four copies each of PostGIS in Action and Java Advanced Topics Training and have the authors on-line!
See this thread and this one for details.
The moose likes Other JSE/JEE APIs and the fly likes Generate Excel Report with , seperated Numeric Data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "Generate Excel Report with , seperated Numeric Data" Watch "Generate Excel Report with , seperated Numeric Data" New topic
Author

Generate Excel Report with , seperated Numeric Data

Kushagra Bindal
Ranch Hand

Joined: Oct 15, 2008
Posts: 156
Hi All,
I want to format the excel report data "," seperated as US format like 1000 as 1,000.
Please suggest me if there is a way to do the same.

Thanks
Kushagra
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42955
    
  73
What is "the excel report data" - does that mean you have an existing XLS file that you're trying to reformat?

You could look into Apache POI; it gives you some control over cell data formatting.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Generate Excel Report with , seperated Numeric Data