Using Spreadsheet::WriteExcel or Excel::Writer::XLSX

Is there a way to write the functions defined in some ADDINs of Excel.

`
$worksheet->write($i,1,"=BDH()"); #fails to write in Excel
`

This above query not able to be interpreted by perl as function/formula. Whereas, below one is written as string in excel but a string not as function. Hence, Excel fails to formulate this string.

`
$worksheet->write_string($i,1,"=BDH()");
`

Please provide some solution to write such formulas in Excel. I know it is not directly supported but there should be some workaround.