aspose 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
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: 41823
    
  62
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