Excel Functions in .Net

  • Thread starter Thread starter Clive
  • Start date Start date
C

Clive

Hi,

I am developing a app that does soem calculations,
rounding etc.

Does anyone know if I can use an Excel Library in .Net in
order to leverage the functions in MS Excel?

Thanks,
Clive.
 
You can. Right click the References section of the Solution Explorer,
select the tab marked "COM" and find the Excel library registered on your
computer.

After making the reference, you should be able to create instances of the
Excel objects and use them.

Be warned though that there is sometimes a performance hit because of the
..NET to COM interoperability that takes place. .NET must make a runtime
callable wrapper for the COM object, thus adding another layer to the
communication chain.

You may want to fully explore the various numeric methods available in .NET.
 
Back
Top