xlw

Introducing DataSlicer Add-In: Advanced Data Analysis in Excel DataSlicer brings over a hundred functions from the pandas DataFrames right into Excel, enhancing your data analysis capabilities. As an early prototype, we’re actively seeking feedback to refine its features and functionality. As we continue to enhance the user experience, we’re also in the process of adding new functions and refining our API. We would appreciate your insights and suggestions; please drop us a line at info@adaptiverisk.

Introduction In this post we describe a technique that allows your Excel addin to be loadable by 32 bit Excel, but lets you run calculations that require more than 2GB of RAM. Most people in financial industry use 32 bit Excel even though they are running it on 64 bit Windows. The main reason for this is backward compatibility - if you have a set of 32 bit addins that you used with previous version of Excel you’ll stick to 32 bit Excel when upgrading.

In the last post I described how to write functions that can input/output arrays, matrices and ranges. For the introduction to XLW series take a look at the first post. Today I am going to describe several useful utilities that are available in XLW. There are many more utilities that are available but they do not work from UDF and only work from macros. This is Excel limitation. I will address creating macros in one of the future posts.

In the last post I described how to write simple functions using XLW. For the introduction to XLW series take a look at the first post. Today I am going to show how write functions that can input/ouput arrays, vectors, matrices or general ranges. The starting point will be the solution we set up in the previous post. If you don’t have set it up you can download it. 1. Numeric array input/output The basic types for input or output arrays or matrices of numbers are:

In the last post I described how to set up a Visual Studio solution to build xll addins using XLW. For the introduction to XLW series take a look at the first post. Today I am going to show how easy it is to create user defined functions (UDF) for Excel using XLW. The starting point will be the solution we set up in the previous post. If you don’t have set it up you can download it.

Update:Added instructions for VS2015 (2016-07-16) The last post was the introduction to the series of XLW related posts. Today I will describe how to set up a project with XLW. XLW comes with an installer that installs the project templates for your development environment. It is a quick way to start, but you don’t have much control over the process and the project template might not match your expectation on how project should be arranged.

This is a first post from a series devoted to building xll add-ins for Excel. Add-ins are used to extend Excel functionality. It is possible to extend Excel using VBA in the same spreadsheet. However this way VBA code is tightly coupled with the spreadsheet, which makes it difficult to keep track of code versions or update code for all copies of a spreadsheet. Users often make copies of spreadsheets because they want to modify something but want to keep original around.