Use single quotes around the value you're looking for:
"/*/rows/row[ValueColumn='value1\"']"
NB: If you need to search for values which contain a mixture of single and double quotes, things become much more complicated. You basically have to split the strings up so that each part only contains one type of quote, use the other type of quote to start and end that string, and use
concat
to combine them. For example:
<row><ValueColumn>I'd like it if "This" was easier!</ValueColumn></row>
"row[ValueColumn=concat(\"I'd like it if \", '\"This\" was easier!')]"
XPath 2.0 apparently makes this easier by letting you escape quotes by doubling them up:
"row[ValueColumn=\"I'd like it if \"\"This\"\" was easier!\"]"
"row[ValueColumn='I''d like it if \"This\" was easier!']"
Unfortunately, .NET has never implemented XPath 2.0, so you this won't work in C#.
c# - Using quotes in Xpath - Stack Overflow[
^]