Signature methods for Excel Functions

Question

Hi All,

I use this dll "Microsoft.Office.Interop.Excel" in order to evaluate my excel functions.

Is there any solution/method allows me to know for each excel function developed in the DLL, their parameters, return type etc...

To be more specific, before calling the evaluate function exposed by the the DLL,
I want to verify for each formula used in my application if the passed parameters type are the correct ones ( In order to avoid any errors written in my formulas).

I read the documentation and didn't found any lead!

thanks,

Answer 1

There is no definitive documentation other than the documentation for writing code inside of Excel itself that in many cases does not properly translate to C#.

Also, I just checked, if you add Microsoft.Office.Interop.Excel to the Visual Studio object browser you can see all classes but not all properties and methods and even when they are exposed lack in any form of documentation.

Answer 2

Not sure if I have understood, but the doc for the "Excel Object Model Reference" is at Microsoft.Office.Interop.Excel Namespace

For example, Application().Workbooks.Open() is Workbooks.Open