That was a fantastic read. In a world of products and apps that seem to be a solution looking for a problem, it's nice to see a full story illustrating a common problem, and how a technical person came to provide a featured solution to that problem.
I think I already know the answer to this, but I assume that this IDE is Windows only? I couldn't see any information about platforms on the main product page, which might throw someone off if they use Excel on a Mac.
There is https://docs.microsoft.com/en-us/office/dev/add-ins/excel/ex... if you wanted to port it to JavaScript! It’s a very weird and badly documented async API, but it is possible to lift out the data and, say, use https://github.com/kripken/sql.js . If you’ve got something good going in VSTO though, I wouldn’t waste time trying to port it. Most people doing corporate reporting are indeed doing it on Windows anyways, I’d imagine.
I think I already know the answer to this, but I assume that this IDE is Windows only? I couldn't see any information about platforms on the main product page, which might throw someone off if they use Excel on a Mac.