Profiling Class Library Loaded in Excel

lcota

I downloaded a demo copy of ANTS Profiler today. My project consists of a class library that is loaded by Excel. I have source code available for the class library (which I developed). How can I profile the performance of the functions contained in this library?

I have tried the following:

Create project with Excel as main app.
Arguments contain .XLL file which is used to expose .NET libraries to Excel

Create .NET project which uses .NET class library
Project launches Excel within itself
Project loads .XLL file to expose functions to Excel

Neither method worked.

Any ideas about how to profile this code?

Tom Harris

Hi there,

I'm not too familiar with excel add ins. Can i just clarify that you have not actually written the add in in .NET, but that the addin makes calls through to another .NET assembly. ANTS Profiler only profiles .NET code so you will only get profiling data for .NET calls. In theory profiling excel itself should be the way to go as long as the addin is loaded in process. Profiling will start once excel loads the CLR. However, it sounds like you've already tried this and it did not work out

If you could send a sample through we could play around with it here?

Many thanks,

Tom Harris

Red Gate Software Ltd.