C#中操纵Excel数学函数？谁能指点我

Question

我的意思是我想使用Excel里丰富的数学函数功能，怎么样才能把它引用的我的C#程序中来？
网上有些讲的是怎么样使用Excel，比如说生成一个Excel.dll，然后引用，可我不知道接下来怎么用它里面的数学函数了

Answer 1

Excel.WorksheetFunction wsf = myexcel1.Application.WorksheetFunction;r1=myexcelworksheet.get_Range(myexcelworksheet.Cells[7,2],myexcelworksheet.Cells[k4+7,2]);myexcel1.Cells[k4+7,i+2]=wsf.Sum(r1,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
这是调用累加功能的示例。^-^

Answer 2

http://www.microsoft.com/china/msdn/library/office/office/UndstaExcelObjModNETDev.mspx