File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Java Interview Guide this week in the Jobs Discussion 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

How to write % in exls through POI

sonu rai

Joined: May 23, 2007
Posts: 22

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 |

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
What code is throwing the URLDecoder exception?
I agree. Here's the link:
subject: How to write % in exls through POI
It's not a secret anymore!