Looking for a good VBA treemap implementation
I need a VBA map object simi开发者_运维知识库lar to C++ STL map class for use in Excel 2010. I am dreading writing one myself, and also dreading writing an XLL. Does anyone know of such an object freely available? Scripting.Dictionary will not do, since I need ordered iteration.
Here's a chapter from a book, hosted on MSDN, that describes creating a binary tree, might be useful to get you started at least: Implementing a Binary Tree
They do mention that there should be sample code on the cd, not sure if you'd be able to download that from there or from the publisher, nor am I sure under what license that sourcecode is provided.
In answer to my own question, the Collection object is available for ordered iteration. However, the only ordering available is on the item number. I eventually created a COM object exposing a std:map using the ATL.
精彩评论