Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to write % in exls through POI

 
sonu rai
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What code is throwing the URLDecoder exception?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic