Hi,
I am newbie to c# coding. I am trying to call the MS-Excel Correl() in my C# code. From a decently comprehensive search on google I found that there is a Excel Interop COM library which could be added as a reference and used.
However i could not find relevant material regarding the usage of the Excel function in C#
using IExcel = Microsoft.Offic e.Interop.Excel ;
IExcel.IWorkshe etFunction wf = new IExcel.IWorkShe etFunctions();
wf.correl(arg1, arg2) // where arg1 and arg2 are two single dim arrays
The code pasted above throws an error as IWorkSheetFunct ion is an interface. I could not find a concrete implementation of IWorkSheetFunct ion.
Can some one help me please ?
I am newbie to c# coding. I am trying to call the MS-Excel Correl() in my C# code. From a decently comprehensive search on google I found that there is a Excel Interop COM library which could be added as a reference and used.
However i could not find relevant material regarding the usage of the Excel function in C#
using IExcel = Microsoft.Offic e.Interop.Excel ;
IExcel.IWorkshe etFunction wf = new IExcel.IWorkShe etFunctions();
wf.correl(arg1, arg2) // where arg1 and arg2 are two single dim arrays
The code pasted above throws an error as IWorkSheetFunct ion is an interface. I could not find a concrete implementation of IWorkSheetFunct ion.
Can some one help me please ?