Excel Services 的托管 UDF 中的内置 Excel 函数
我正在考虑将一组 VBA 函数移动到 VB.Net，目的是使用它们在 Excel Services 和 Sharepoint 中执行服务器端计算。我的理解是我需要为此创建一个托管 UDF。
我的问题与我在 VBA 中使用的内置 Excel 函数有关：
Application.Sum
Application.SumSq
Application.Count
Application.Average
Application.StDev
Application.Skew
Application.Kurt
Application.Min
Application.Max
Application.NormSInv
Application.TInv
Application.TTest
Application.VarP
Application.MDeterm
Application.MInverse
Application.MMult
Application.Transpose
Application.LinEst
Application.Index
Application.WorksheetFunction.RSq
Application.WorksheetFunction.Correl
Excel Services 会认识到这些是本机 Excel 函数吗？如果是这样，我需要在 .Net 中做什么才能使 Excel Services 知道这些函数是 Excel 的本机功能？如果可能的话，任何有效的例子将不胜感激。
或者我会更好地使用这些函数的 .Net 替代品吗？如果是这样，您是否可以向我指出一个来源来解释本机 Excel 函数到 VB.Net 函数的映射？
或者我被迫将这些标准函数重写为自定义函数？
非常感谢您的帮助。
问候， 杰康
I’m thinking of moving a set of VBA functions to VB.Net with the objective using them to perform server-side calculations in Excel Services and Sharepoint. My understanding is that I need to create a managed UDF for this.
My question relates to the built-in Excel functions I’ve been using in VBA:
Application.Sum
Application.SumSq
Application.Count
Application.Average
Application.StDev
Application.Skew
Application.Kurt
Application.Min
Application.Max
Application.NormSInv
Application.TInv
Application.TTest
Application.VarP
Application.MDeterm
Application.MInverse
Application.MMult
Application.Transpose
Application.LinEst
Application.Index
Application.WorksheetFunction.RSq
Application.WorksheetFunction.Correl
Will Excel Services pick up on the fact these are native Excel functions? If so, what do I need to do in .Net to make Excel Services aware that these functions are native to Excel? Any worked examples would be greatly appreciated if this is possible.
Or would I be better of using .Net alternatives to these functions? If so, is there a source you can point me to which explains the mapping of native Excel functions to VB.Net functions?
Or am I forced to re-write these standard functions as custom functions?
Many thanks in advance for your help.
Regards,
JK
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
AFAIK 你应该能够使用 XLApp.WorksheetFunction.fn （除非这些函数位于分析工具库中，快速扫描你的列表看起来没问题）
AFAIK you should just be able to use XLApp.WorksheetFunction.fn (unless the functions are in the Analysis Toolpak which doing a quick scan of your list looks OK)