Serving the Quantitative Finance Community

 
User avatar
Ouyang
Topic Author
Posts: 0
Joined: January 17th, 2002, 5:42 am

Can we export overloaded functions from xll files?

January 31st, 2002, 7:22 pm

Is it possible? We can used overloaded functions inside xll files, but can we export them to excel?
 
User avatar
Jim
Posts: 1
Joined: February 1st, 2002, 5:20 pm

Can we export overloaded functions from xll files?

February 1st, 2002, 5:34 pm

Yes and no. For each function the .xll exports to Excel, it must register that function. The registration process tells Excel the name of the function, the number and type of arguments the function takes, the return type, some help info about each argument, and the (possibly overloaded) internal name the function has inside of the .xll. The "external" name which Excel publishes must be unique for a given .xll, so no overloading there. But overloaded functions can definitely be exported, they just need different names inside of Excel.

This and more is in the Excel97SDK available from Microsoft.