question

YamenJeribi-2720 avatar image
0 Votes"
YamenJeribi-2720 asked emizhang-msft commented

Signature methods for Excel Functions

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,

dotnet-csharpoffice-excel-itprooffice-scripts-excel-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @YamenJeribi-2720,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

0 Votes 0 ·
karenpayneoregon avatar image
0 Votes"
karenpayneoregon answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Castorix31 avatar image
0 Votes"
Castorix31 answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.