Jamaica Finance

Jul 4 2018

How can I read numeric strings in Excel cells as string (not numbers) with Apache POI? Stack Overflow

#prepend #cell #phone # Gagravarr s warning against doing this is right! From the docs: If what you want to do is get a String value for your numeric cell, stop. This is not the way to do it. Instead, for fetching the string value of a numeric or boolean or date cell, use DataFormatter instead. poi.apache.org/apidocs/org/apache/poi/ss/usermodel/ I was using this technique myself until I wound up accidentally changing data I didn t intend to change. (Set type to String, read value, set type back to numeric, read again and get a different numeric value!) cfinley Jul 31 ’15 at …