Excel Extensions

Excel Extensions is an Excel 2007 addin written in C#. It offers some useful extensions to Excel's inbuilt features while demonstrating how to extend Excel 2007 in managed code.

Over time I will add more and more features.

Feature List

Analyse Column
Displays statistical information of the values within a table column. The data is displayed in a DataGridView control using a custom drawn cell to mimic Excel's conditional formatting.

More details can be found at my blog: http://blogs.msdn.com/gabhan_berry/default.aspx

UNIQUEVALUES Worksheet Function
Returns the unique values within a specified range. The values are returned as an array. The range can contain numerical and/or textual data.

More details can be found at my blog: http://blogs.msdn.com/gabhan_berry/archive/2008/04/07/writing-custom-excel-worksheet-functions-in-c_2D00_sharp.aspx

Downloads

• ExcelExtensionsSrc.zip: the entire source code;
• ExcelExtensions.msi: a set up program which can be used to install the addin without having to compile the source code;