Single quotes not handled correctly?

Topics: Developer Forum
Mar 8, 2011 at 8:35 AM

When I set a cell to a string value that contains a single quote, I get an XPath exception. For instance, this fails

worksheet.Cell(row, 7).Value = "Bio with ' in it ";

Fails with '//d:si[d:t='Bio with ' in it ']' has an invalid token.

Mar 24, 2011 at 6:43 PM

ditto

Mar 24, 2011 at 7:04 PM

after looking through the discussions, there is a a way to make it work that others have discoverred, but you will need to alter the source and compile yourself.

Mar 25, 2011 at 5:21 AM

And which post is it that is the appropriate fix?

Apr 28, 2011 at 7:43 AM
Edited Apr 28, 2011 at 7:43 AM

Hi,

do you able fix this, if please post how you did this.. Thanks

May 25, 2011 at 3:55 PM

here is how you can make changes in Source Code to fix single quote problem

check out answer by "atmacam"

http://excelpackage.codeplex.com/discussions/7152