Is there a way to capture the first single quote when using the HSSFCell class for a text field cell. For example: 'xyz' is in the excel spreadsheet cell. When I call the method getStringCellValue() to retreive the value I only get xyz' minus the first single quote. I am able to retreive the first single quotes if I escape it in excel as ''xyz' but I do not want to require my users to remember to escape single quotes every time. Is there a way around this? Thanks, Eddy
- Single quotes in text cells Eddy Wu \(C\)
- Re: Single quotes in text cells Jim Cobban
