Looking for a free way to develop Excel add-ins with IronPython?

I don’t know much about VSTO or VSTA, but I think you need the full version of Visual Studio to use one of them. I cannot convince my boss to buy us, but I would like to develop Excel addins in IronPython. I looked through several tutorials that show how to interact with Excel using IronPython, but I can't learn much about add-on development. Can you recommend any resources?

Is my only option for creating incremental COM? If so, does anyone know about this example using IronPython?

I am sorry to say that I cannot go with any options that include spending money. I have free Visual Studio Shell and IronPython tools to create a free visual studio right now.

+4
source share
3 answers

First of all, you are right, unfortunately VSTO is not supported in Visual Studio Express, a free version of VS.
Then you can see ExcelDNA . I have not tried this specifically with IronPython, but it should work. ExcelDNA is a free library that allows you to create Excel xll add-ins and use .NET up to version 4.

+2
source

Another Codeplex project might help: xll.codeplex.com . It really depends on how easy it is to call IronPython from C ++.

+1
source

Is the "plain old" VBA add-on out of the question? It will be smaller, faster to implement, easier to deploy.

+1
source

Source: https://habr.com/ru/post/1342469/


All Articles