
Excel
Get flash to fully experience Pearltrees
Excel
Have you ever wanted to create your own functions in Excel? There are several ways to accomplish this goal, all have their strengths and weaknesses. The options for creating a custom function are listed in the table below. In this post we’ll be looking at the easiest option that requires only Excel. The other options are more difficult and time consuming but the advantage is increased speed.
Guide to Writing Custom Functions in Excel: Part I, Using VBA
How to call C functions from Excel using a DLL written in C (or C++) - Jonathan R Lhost
As part of my research, I wanted to combine the speed of C with the ability Excel provides to easily visualize and process substantial quantities of information. From the documentation and message boards scattered around the internet, along with a healthy does of experimentation, I was able to get it working quite well. What previously took 2 hours using only Excel and VBA (even with all the tricks I've learned over the years to make Excel about as fast as possible), now takes just seconds with the C functions doing most of the work. If the task is something you need to do a few hundred times, it can now be completed in an hour instead of a month.Introduction In the previous article , we looked at writing custom functions that can be used in Excel formulas using VBA. VBA has the advantage of being easy and quick. An automation add-in is another option that is also very easy assuming you know a bit about C++ programming.
Guide to Writing Custom Functions in Excel: Part II Automation Add-In
Guide to Writing Custom Functions in Excel: Part III, C++ RTD add-in
Introduction In the previous article we developed a custom function in Excel using an Automation Add-in. It was fairly straightforward and didn’t take long but performance isn’t one of it’s strengths and there is no way to properly document it within Excel for the user. The RTD is an automation add-in that implements the IRtdServer interface so creating it is similar.Custom Functions in Excel: Part IV, XLLs
Introduction Why would you want to call an RTD from an XLL? Recall that the way to call an RTD is through the RTD function in Excel, so the user needs to somehow remember how many parameters your function takes and in what order to supply them and even what the function is called. Good luck explaining that to your users! =RTD( " rtdexample.simplertdserver.1" , " " , 1 . 5 , 2 . 5 , 3 . 5 ) Exhibit 1: The example from part 3 of this series.
Custom Functions in Excel: Part V, XLL-RTDs
Python Tools for Visual Studio - Home
pyinex - A project to embed Python in Excel
Pyinex is a project to embed the Python interpreter in Excel. This is in contrast to the usual approach to linking the two systems, in which Python scripts run in an out-of-process COM server and Excel makes a cross-process call to use Python functionality. In Pyinex, Python runs from a DLL in the Excel process space. This embedding offers the advantage of speed (no cross-process calls) and reduced fiddliness.Python Excel
ython for Excel (PFE) brings robustness to Python scripting for Excel and provides a complete set of tools for building fully featured applications with Excel front end. It is an in-process control of Excel with an out-of-process developement and debugging environment. Python for Excel mimics VBA in the manner of control of Excel application, simplicity of programming style, syntax and naming of object model. Functionality of an Excel workbook is controled by a Python script placed in the same directory.Overview of XML in Excel - Excel
James Rivera Frank Rice Microsoft Corporation February 2005 Applies to: Microsoft Office Excel 2003 Summary: Learn how to use the Microsoft Office Excel 2003 XML Tools Add-in Version 1.1.
Using the Excel 2003 XML Tools Add-in Version 1.1
Sergei Gundorov Clark Hamilton Microsoft Corporation March 2005 Applies to: Microsoft Office Editions 2003 Summary : In the first of a three-part series, learn how to use XML maps to customize Excel as a data input and display system. (20 printed pages) Contents
Part 1: Automating the XML Data Mapping Process in Excel 2003
Creating XML Mappings in Excel 2003
Frank Rice Microsoft Corporation February 2005 Applies to: Microsoft Office Excel 2003Peter Vogel PH&V Information Services March 2004 Applies to: Microsoft® Office Excel 2003 Microsoft Office System Summary: Connecting workbooks to data sources so that spreadsheets can manipulate and update data is a common goal in Office-based solutions.

