How to Create Source File

Excel Ignite is an Excel add-on that allows users to retrieve data from online APIs, as User Defined Functions (UDF). To make your API accessible through Excel Ignite, all you need to do is to create an XML-based Source file, which defines

Available functions, API end points and their inputs

How the Excel Ignite would connects to the corresponding APIs, with the inputs provided

Detailed mapping between API response and available outputs for the Excel function

The APIs can be publically accessible or local to a specific environment. The following is instruction of how to create a source file.

Source File Examples

Excel Ignite uses source files to define Excel UDFs. The file name should be the same as the source defined here, with .xml extensions. You can define multiple functions within a single source file. Here is a high level structure of the source file:

Deployment

Once the source file is created, in order to use it, Excel users just need to drop the file to the Ignite source file folder to deploy it. =Ignite_Browse() function will open Windows Explorer in the folder where sources files are kept.