I'm finally able to extract the normal text and the superscript content separately. This is what I did :
If you have a content such as 'ABC2 Some text2', where both the 2s are superscript, then numFormattingRuns() in XSSF is returning value 4 (i.e) ABC, 2, some text and 2. However, HSSF is returning only 3 (i.e) ABC2, some text and 2. However, getIndexOfFormattingRun(0) returns value 3 (i.e) index of the superscript. So for the first formattingrun alone I get substring(0,getIndexOfFormattingRun(0)) and for the remaining formattingruns I get substring(getIndexOfFormattingRun(i),getIndexOfFormattingRun(i+1)). I still haven't tested it fully but hey atleast it's a start. And thanks for all your help Mark. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-superscript-from-data-cell-tp3414964p3445867.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
