What is an Excel XLL Add-in (Excel 2010 Training)

a library for creating xll add-in’s for Excel from 97 through 2010. It makes every feature of the Excel 2010 SDK available to you including the big grid, wide character strings, and asynchronous functions. It is the easiest way to integrate your C and C++, or even Fortran, code into Excel to achieve the highest possible performance. You can also generate native documentation using the same tool Microsoft uses for their help files.

If you need a small, fast, portable, and self contained way to extend Excel’s functionality, this is the library for you. Just hand someone the xll and chm help file that you create and they are ready to go. No need to figure out what version of .Net they run, no Primary Interop Assemblies to worry about, no managed code that forces you to marshal data back and forth from Excel. There are also no automagic code generators, no proprietary markup languages to learn, and no wizards that hide things behind your back. Everything is just pure, modern, and readable C++.

INSTALLATION

Run setup.msi and project.msi. You will need to install htmlhelp.exe from Microsoft’s HTML Help Workshop to build documentation.

OPERATION

Start Visual Studio 2010. This works with the free version of Visual C++ 2010 Express
File > New > Project… select XLL AddIn Project.
Right click on your project, Build.
Right click on your project, Debug > Start new instance.

If all goes well, you should see XLL.FUNCTION show up under My Category in the Function Wizard. You can set breakpoints by clicking to the left of any line in the source code for xll_function in the file function.cpp.

To create HTML Help documentation, hit Alt-F8 then run XLL.DOC. Click on Help on this function in the Function Wizard to start the help viewer.

Function Wizard

INSTALLATION AND OPERATION VIDEOa library for creating xll add-in’s for Excel from 97 through 2010. It makes every feature of the Excel 2010 SDK available to you including the big grid, wide character strings, and asynchronous functions. It is the easiest way to integrate your C and C++, or even Fortran, code into Excel to achieve the highest possible performance. You can also generate native documentation using the same toolMicrosoft uses for their help files.

If you need a small, fast, portable, and self contained way to extend Excel’s functionality, this is the library for you. Just hand someone the xll and chm help file that you create and they are ready to go. No need to figure out what version of .Net they run, no Primary Interop Assemblies to worry about, no managed code that forces you to marshal data back and forth from Excel. There are also no automagic code generators, no proprietary markup languages to learn, and no wizards that hide things behind your back. Everything is just pure, modern, and readable C++.

INSTALLATION

Run setup.msi and project.msi. You will need to install htmlhelp.exe from Microsoft’s HTML Help Workshop to build documentation.

OPERATION

Start Visual Studio 2010. This works with the free version of Visual C++ 2010 Express
File > New > Project… select XLL AddIn Project.
Right click on your project, Build.
Right click on your project, Debug > Start new instance.

If all goes well, you should see XLL.FUNCTION show up under My Category in the Function Wizard. You can set breakpoints by clicking to the left of any line in the source code for xll_function in the file function.cpp.

To create HTML Help documentation, hit Alt-F8 then run XLL.DOC. Click on Help on this function in the Function Wizard to start the help viewer.

Function Wizard

INSTALLATION AND OPERATION VIDEO

Leave a Reply

Your email address will not be published. Required fields are marked *