在Excel中有多少种编程方法.VBA除外 [英] how many ways to do programming in Excel . except for VBA
问题描述
我想用一些复杂的功能在excel中处理数据.看来我必须使用VBA.
I want to manipulate data in excel with some complex functions. It seems that I have to use VBA.
但是我不想学习它.在Excel中还有其他方法可以进行编程吗?像C#这样的语言?
However I don't want to learn it. Is there any other way to do programming in the excel? Some language like C#?
我不想使用Excel提供的某些界面来创建独立的C#应用程序.只能使用excel程序(例如VBA),但是要使用其他语言.
I don't want to create a independent C# application using some interface provided by Excel. Only program in excel, like VBA, but a different language.
推荐答案
我不想使用Excel提供的某些界面来创建独立的C#应用程序.只能使用excel程序(例如VBA),但是要使用其他语言.
I don't want to create a independent C# application using some interface provided by Excel. Only program in excel, like VBA, but a different language.
很遗憾,您不能.要在Excel中使用 Excel进行编程,您将必须学习VBA.
You cannot unfortunately. To program in Excel from within Excel you will have to learn VBA.
要为Excel编程,无论是VBA,VSTO(C#,VB.Net),您都需要了解Excel对象模型( EOM ),否则您将无法为Excel进行编程.
To program for Excel, be it VBA, VSTO(C#, VB.Net) you need to understand the Excel Object Model (EOM) without which you cannot do programming for Excel.
如果您想从C#开发Office解决方案,则无需学习VBA本身,但是随着您对EOM的熟悉,您会发现您会自动对VBA有所了解.
You don't need to learn VBA per se if you want to develop Office solutions from C# but as you become familiar with the EOM, you will notice that you automatically develop an understanding for VBA.
编辑
这篇关于在Excel中有多少种编程方法.VBA除外的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!