C# as a scripting language
Let us code macros directly in C#!
I used C++ for a few years and I came here intending to suggest making C++ an alternative macro language. C# seems popular but I have no experience with it. I could probably learn.
As things stand I have written several macros in VB Basic for Excel and would hate to see VB disappear. Why not make C# an option? It sounds like I would enjoy learning and using it.
John Wakefield commented
I want to code functions and macros in C#
richard daniels commented
Excel DNA by Govert is excellent. I recommend that anyone that wants to use C# as an alternative or as a complementarry langugage in Excel take look at it..
Sergey Vlasov commented
I've recently released ESharper add-in (https://vlasovstudio.com/esharper/) to write UDF and scripts in C# directly in Excel in a live session.
It would be great to be able to use all .Net languages. Different problems can be addressed much more efficiently in C#/F#/VB.Net
Govert: and I am a big fan and a big user of ExcelDNA. But it would still be nice to be able to write scripts and UDF in .net directly in Excel in a live session
With Excel-DNA (http://excel-dna.net), any .NET language - C#, VB.NET or F# - can be used to make macros and high-performance user-defined functions.
Roslyn is a portable C# compiler that you can use on all platforms. Why not support your own modern languages in Excel for writing macros rather than just long-dead VBA?
Jesse Fu commented
I just want to use all the OOP features in .NET.