A while ago, as a hobby and later a business, I made an Excel plugin for using SQL in Excel:
https://www.querystorm.comI've now added the capability to use C# in Excel, using Roslyn. Sort of like Linqpad in Excel. This lets it work with Excel tables, fiddle with formatting, and automate stuff.
Some of the practical applications:
- processing data in Excel (LINQ)
- getting data from various sources into Excel (REST, databases, files, active directory, whatever)
- building interactive dashboards
- building prototypes applications (you write logic in C# and use Excel as the UI and data storage)
Here's the introduction:
https://querystorm.com/documentation.htmlThere's also a short video: https://vimeo.com/242216594 for a brief intro.
I charge for the plugin but it's freemium. If you don't want intellisense, error squigglies and so on, you don't need a license.
So... what do you think?
I've now added the capability to use C# in Excel, using Roslyn. Sort of like Linqpad in Excel. This lets it work with Excel tables, fiddle with formatting, and automate stuff.
Some of the practical applications:
Here's the introduction: https://querystorm.com/documentation.htmlThere's also a short video: https://vimeo.com/242216594 for a brief intro.
I charge for the plugin but it's freemium. If you don't want intellisense, error squigglies and so on, you don't need a license.
So... what do you think?