Have you read the section Formulas and Functions in Excel in the Spreadsheet::WriteExcel documentation? I think it is not possible to use functions declared in an Add-In with these modules.