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’!…...added with Excel formula while exporting to Excel Aspose.Cells...Cells Product Family saving-excel , set-formula , aspose-cells anjali...