Microsoft.Office.Interop.Excel.WorksheetFunction does not contain all the functions in excel

Question

I am trying to call excel functions from C#. I can use the following code to get the excel functions:

Application app = new Application();
WorksheetFunction functions = app.WorksheetFunction;
var sum = functions.Sum(1, 2);

I can get the function like SUM from the WorksheetFunction object. But now all the functions are there, like LEFT, RIGHT, DATE etc. Can I find them somewhere else?

I've always assumed it's because those functions exist in VBA, or in your case, C#. Can you just use the C# LEFT, RIGHT or DATE, etc., functions? — Doug Glancy, Apr 22 '13 at 19:57
Possible duplicate of [.Net equivalent of the old vb left(string, length) function?](https://stackoverflow.com/questions/844059/net-equivalent-of-the-old-vb-leftstring-length-function) — puzzlepiece87, Aug 29 '19 at 18:01

score 0 · Answer 1 · edited Mar 17 '22 at 09:11

0

Try something like below for example

using Microsoft.Office.Interop.Excel;

static void Main(string[] args)
{

     Application a = new Application();
     double x = a.WorksheetFunction.Sum(1, 2);
     Console.WriteLine("Sum = {0}", x);

}

EDIT

using IExcel = Microsoft.Office.Interop.Excel;

Then declare and initialise a IWorkSheetFunction object

IExcel.IWorksheetFunction iwf = new IExcel.IWorksheetFunction();

Now you can use the functions as in

double result = iwf.NormDist(1,2,3,4);

edited Mar 17 '22 at 09:11

serge

13,940
35
121
205

answered Apr 22 '13 at 18:15

tam tam

1,870
2
21
46

Sum is in the WorksheetFunction. LEFT, RIGTH, Date are not. – Ryan Apr 22 '13 at 18:23
This interface does not have LEFT, RIGHT and DATE functions – Ryan Apr 22 '13 at 18:48

Microsoft.Office.Interop.Excel.WorksheetFunction does not contain all the functions in excel

1 Answers1