File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
Marshal

Joined: Mar 22, 2005
Posts: 41137
    
  45
What code is throwing the URLDecoder exception?


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to write % in exls through POI
 
Similar Threads
Why "539" and not "1"?
How i will display Total Value for all the page
how to add numbers in string
POI Excel Large Function shows #VALUE!
crystal report using sql server db