This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread 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: 42958
    
  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
 
It's not a secret anymore!