Example code i am trying c#
temppc = "=\""+ i.ProductCode+"\"";
workSheet.Range[row, 3].Text = temppc; //tried Value too same result
For a cell i am trying to get this as text ="xxxxxxxx"
however the spreadsheet will have "=""01896""" and will save that to a csv file.
workSheet.SaveToFile(itemFileName, separator);