rkapl123/DBAddin

This system is an Excel add-in that enables users to interact with various relational databases directly within the spreadsheet environment. It provides core capabilities for executing ad-hoc SQL queries, mapping data to and from Excel sheets, and performing standard database operations like insert, update, and delete. The add-in supports multiple database backends, including Oracle, DB2, and SQL Server, and is distributed with automated deployment scripts and configuration management for both central and user-specific settings.

The Distribution folder now contains the complete set of files required to install and configure the DB Addin. This includes the main add-in configuration (DBaddin.xll.config) which sets the .NET 4.7.2 runtime target and configures logging via ExcelDNA, alongside separate central (DBaddinCentral.config) and user (DBaddinUser.config) settings files that define database connection profiles (Oracle, DB2, MSSQL, Postgres, Access, MySQL) and add-in behaviors. Deployment is automated via a Windows script (deployAddin.cmd) that handles copying the add-in to the Excel AddIns directory and updating registry keys, while a helper script (createTableViewConfigs.vbs) allows for the generation of table/view configurations from a database schema.

Distribution · high confidence

This entry marks the first public release (version 1.0.0.57) of the Excel Add-in. It introduces the core database management capabilities, including the AdHocSQL tool for executing and transferring SQL queries, the DBMapper for inserting, updating, and deleting data, and the DBSheet feature for managing Excel sheets as database tables. The release also includes the AboutBox dialog for version information, update checks, and legacy function repair, along with the necessary project configuration and build artifacts.

source · high confidence

The DBAddinUnitTests project now includes the standard Visual Studio 'My Project' infrastructure files (Application, AssemblyInfo, Resources, and Settings) required for a .NET Framework 4.7.2 target. This change establishes the necessary project structure and metadata for the unit test assembly, aligning with the upgrade to .NET 4.7.2.

DBAddinUnitTests/My Project · high confidence

The build now includes the previously missing AssemblyInfo, Resources, and Settings configuration files for the DB Addin. AssemblyInfo sets the assembly version to 1.0.0.112 and defines metadata such as the title, description, and copyright. Resources and Settings files are added to support localized string lookups and application configuration storage, ensuring the add-in can properly manage its internal settings and resources during runtime.

source/My Project · high confidence

96 commits adding/updating tests in test; Added unit tests for DBAddin utility functions.

The DB Add-in and its unit test project have been upgraded to target the .NET Framework 4.7.2 and updated to use ExcelDna version 1.9.0 (including Integration, IntelliSense, Registration, and AddIn packages). This change also introduces the ExcelDna.Interop package (version 16.0.0) to manage Office interop references, replacing previous dependency configurations.

(dependencies) · high confidence

Written by watchdog.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

• CAI 36 → 33 (-2.8)
• Rubric changed (rubric-2026.09.11 → rubric-2026.09.18) — scores are not directly comparable.

• Code Health 25 → 25 (+0.3)
• Architecture 90 → 93 (+3.7)
• Maturity 52 → 52 (+0.2)
• Readiness 33 → 23 (-10.2)
• Security 50 → 50 (+0.0)

• ClassTooLong: ConfigFiles (source/ConfigFiles.vb)
• Coverage not measured — no coverage collector is wired up
• Documentation: no installation or build instructions (docs/README.md)
• Hotspot: source/AddInEvents.vb (source/AddInEvents.vb)
• Hotspot: source/DBModif.vb (source/DBModif.vb)
• Hotspot: source/DBModifHelper.vb (source/DBModifHelper.vb)
• Hotspot: source/DBSheetConfig.vb (source/DBSheetConfig.vb)
• Hotspot: source/Functions.vb (source/Functions.vb)
• Hotspot: source/MenuHandler.vb (source/MenuHandler.vb)
• Hotspot: source/SupportingTools.vb (source/SupportingTools.vb)

• Documentation: no installation or build instructions (docs/devdoc/4294967819.htm)
• Documentation: no usage examples (docs/devdoc/4294967819.htm)
• Duplicated block (10 lines × 2) (source/MenuHandler.vb)
• EmptyCatchBlock (source/AddInEvents.vb)
• MethodTooLong: MenuHandler.showDBAdHocSQL (source/MenuHandler.vb)
• No automated tests
• No tests found

• 1 commits — 1 feature/other, 0 fixes

• Distribution/DBaddin32.xll — 1 commit

• change: corrected transfer into target cell from AdHocSQL for queryStrings > 255 characters (put query into separate cell and refer to that) separated building ContextMenuStrip for AdHocSQL context menu, now built directly from ConfigFiles.ConfigMenuXML (ribbon tree menu) Get exact excel version now to avoid problems with special builds (like building ConfigMenuXML twice for ribbon)

Written by watchdog.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

rkapl123/DBAddin was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.