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 Open Source Projects and the fly likes How to write % in exls through POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "How to write % in exls through POI" Watch "How to write % in exls through POI" New topic
Author

How to write % in exls through POI

sonu rai
Greenhorn

Joined: May 23, 2007
Posts: 22
Hi,

I m using POI to export report in xls. My problem is .

1. I have saved report with % sign in report name.(e.g aa%dd%fd) . it throws an exception.
URLDecoder: Illegal hex characters in escape (%) pattern - For input string: "f/"

2. I have value with percent sign in a cell (e.g 20.55%) and other cells have double value
but when i add them , it can't add the value, 20.55% is an string value.

E.g I want to calculate the sum of

----------------------------------------
| 20.55% | 1234 | 1234.20 | Sum |
----------------------------------------

thank's
Prem
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42958
    
  73
What code is throwing the URLDecoder exception?
 
Have you checked out Aspose?
 
subject: How to write % in exls through POI
 
It's not a secret anymore!