I have used a formula like below, means when there is sheetname soon after the ‘=’ sign then additional symbol ‘@’ comes it self while exporting the excel.
e.g:
string strFormula = "IFERROR(IF(MATCH(1,(D1=‘sheet name’!…... The cells highlighted in red are having @ symbol...