Today, I want to show you a simple user defined function (UDF) for a Delphi XLL that evaluates a function parameter passed in as an Excel Range. This example was requested by a visitor of my glade.
Surprisingly, many visitors are interested in writing XLL add-ins for Excel. Today, I want to describe a Delphi sample add-in which adds a custom menu to the menu bar. This sample applies to Excel 11 and before. The custom menu will appear in the Add-Ins tab of new releases of Excel. Continue reading
A DLL just needs to provide the xlAutoOpen function to become a valid XLL Add-In. It’s quite easy to say ‘Hello Excel!’ with Delphi that way. The xlAuto family is a set of interface functions Excel uses for XLL interaction. Continue reading
Excel enables a DLL to call back into Excel. Your Delphi Add-In will need to use this feature provided with the Excel4v and Excel12v callback functions. We import the Excel4v function and implement the Excel12v function. Hence we’ve got the objects to write Delphi XLL Add-Ins. Continue reading
You need some basic objects to create Excel XLL Add-Ins with Delphi. At first, we need a structure to exchange data with Excel. Therefore, Microsoft describes the XLOPER and XLOPER12 structures inside the Excel Software Development Kit (SDK). Continue reading