A WebPack plugin (v2.1.7) for Office Add-ins that generates the metadata JSON file required by Excel custom functions. It pairs with the Custom Functions runtime to define function names, parameters, and descriptions. This plugin is specific to the Office Add-in development lifecycle and requires WebPack 5. It is part of the Office-Addin-Scripts monorepo maintained by Microsoft. Key differentiators: it auto-generates metadata from JavaScript/TypeScript comments, integrates tightly with WebPack 5, and is the official Microsoft tool for enabling Excel custom functions in web add-ins.
npm install custom-functions-metadata-pluginVerified import paths — ran on the pinned version, not inferred.
Shows how to add the plugin to a WebPack config to generate Excel custom functions metadata from a source file.
Update WebPack to version 5 or stay on plugin v1.x.
Add @customfunction JSDoc tag and parameter descriptions to each exported function.
Use `office-addin-manifest modify` for manifest changes instead of relying on this plugin.
Add input: './path/to/functions.js' to the plugin options.
Ensure input file exports functions with JSDoc comments and is a valid module.