-1

I have string "my string" taken from excel value, I used GemBox.Spreadsheet library. But the result I have """my string""". How to get back my real string value as "my string

Thanks

ranggadablues
  • 249
  • 1
  • 4
  • 14
  • Check this: https://dotnetfiddle.net/xU15IJ – Aditya Singh Jul 02 '15 at 04:09
  • have you tried the `string.Replace` method can you show us what you have tried vs you telling us what other people have posted doesn't work.. – MethodMan Jul 02 '15 at 04:57
  • @MethodMan I already tried with `string.Replace` does not match what I expected. And you can see my own answer below, the result from convert file is same as what I got on my script. once again thanks for all participate and sorry if my question not clear – ranggadablues Jul 02 '15 at 06:35

2 Answers2

0

Use the hex escape \x22 such as:

Console.WriteLine ("\x22Literally\x22");

Outputs "Litterally"

ΩmegaMan
  • 29,542
  • 12
  • 100
  • 122
  • sorry still not work. I know it's should real value I get from excel, after save to csv the string write with double quote three times. – ranggadablues Jul 02 '15 at 03:48
0

okay I just go to GemBox Convert I try upload my excel file, then convert into csv file, and the result is same as my convert file. So the problem is not coming from my script but in GemBox.Spreadsheet library. Thank you for your participate guys!

ranggadablues
  • 249
  • 1
  • 4
  • 14