Set an excel cell/range formula which contains quotation mark error. (0x800A03EC))
I use interop.excel library.
I want to set this string to the formula of some excel range: =HA(VAGY(C2=”83V”;C2=”8U”;C2=”9V”);”nem”;”igen”)
English: =IF(OR(C2=”83V”;C2=”8U”;C2=”9V”);”no”;”yes”)
After I copied it into visual studio backshashes were automatically added to the string:
“=HA(VAGY(C2=”83V”;C2=”8U”;C2=”9V”);”nem”;”igen”)”