how to use built in functions for excel in office app development

Question

I am trying to develop office app for Excel for that i want to use the built in functions of excel like abs,sum,Avg and so on.

I have gone through the office app documentation but didn't found any solution

https://msdn.microsoft.com/library/office/jj220082.aspx

Can any one suggest what is the best way to achieve this.

Thanks.

Answer 1

You should be able to find what you need in the VBA functions. A good list of them is here. Just prepend the functions with vba. when using them. For example:

Dim LResult As String

LResult = VBA.Left("Alphabet",3)