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.