String unformattedContents ( ) { switch ( currentCell . getType ( ) ) { case "s" : //string stored in shared table if ( ! lastContents . isEmpty ( ) ) { int idx = Integer . parseInt ( lastContents ) ; return new XSSFRichTextString ( sst . getEntryAt ( idx ) ) . toString ( ) ; } return lastContents ; case "inlineStr" : //inline string (not in sst) return new XSSFRichTextString ( lastContents ) . toString ( ) ; default : return lastContents ; } }
Returns the contents of the cell with no formatting applied