Recent Comments
Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor… Rick Rothstein on Excel formula to test if a wor… Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor…
Monthly Archives: Jul 2012
String fuzzy matching in VBA and VB.Net
This describes how I speeded up a slow VBA string similarity function by first optimising the VBA and then migrating to VB.Net with Excel-Dna. If you’re a follower of Charles Williams’ FastExcel blog, none of this will be new to … Continue reading
Posted in Excel/VBA, ExcelDna, Productivity
Tagged code, efficiency, fast Excel, fast VBA, fuzzy matching, optimisation, Performance, similarity, speed, String comparison, VB.Net
5 Comments
Open Source Data Visualisation Add-in includes Treemap
In answering a question on the Excel-L list, I discovered Fabrice Rimlinger’s Open Source Excel addin for data visualisation. Although it’s called Sparklines for Excel, it has more than that, and the code is GNU public domain.
Posted in Excel/VBA
Tagged addin, color, Excel, OSS, pattern, public domain, Treemap
Leave a comment
Patrick O'Beirne @ sysmod 