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’!…...application (runnable), zip the project to post us with template Excel...well as v23.11.0 I have an ‘.xlsx’ file pre-filled with formulae...