I had same problem. I did cell.setCellType(Cell.CELL_TYPE_STRING);
before reading the string value, which solved the problem regardless of how the user formatted the cell.
More Related Contents:
- Best language to parse extremely large Excel 2007 files [closed]
- How to read Excel cell having Date with Apache POI?
- Embed files into Excel using Apache POI
- Apache POI – FileInputStream works, File object fails (NullPointerException)
- Apache POI add a Series name into LineChart
- Apache poi Excel line chart points
- How to set axis’ labels in a Line Chart using Apache Poi
- Removing a row from an Excel sheet with Apache POI HSSF
- Apache POI autoSizeColumn Resizes Incorrectly
- What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
- Merging cells in Excel using Apache POI
- Password Protected Excel File
- how to read exact cell content of excel file in apache POI
- Create Bar Chart in Excel with Apache POI
- Excel Cell Style issue
- How to insert a row between two rows in an existing excel with HSSF (Apache POI)
- Exception when writing to the xlsx document several times using apache poi 3.7
- Apache-POI sorting rows in excel
- Java POI : How to read Excel cell value and not the formula computing it?
- Create a password protected Excel file using Apache POI?
- Apache POI evaluate formula
- Embed files into XSSF sheets in Excel, using Apache POI
- Apache POI Line Chart colors
- Java POI the supplied data appears to be in the Office 2007+ XML
- Determine MS Excel file type with Apache POI
- Make column read-only using apache poi
- Writing a large resultset to an Excel file using POI
- Replacing a text in Apache POI XWPF
- Getting Exception(org.apache.poi.openxml4j.exception – no content type [M1.13]) when reading xlsx file using Apache POI?
- how to add a picture to a .docx document with Apache POI XWPF in java