Excel Functions in .Net

[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.

 

[abacnet]

Yes you can, just add the reference to Excel from the COM tab.
Imports Excel

Dim e As New Excel.Application()
Dim r As Excel.Range
Dim ws As Excel.Worksheet
Dim c As Excel.Chart
etc...

 

[Steve C. Orr, MCSD]

Just keep in mind that this is not very scalable.
Excel wasn't designed to be a server component.
The threading model is designed for a single user desktop environment.

 

[abacnet]

I usually use it only to extract data from my desktop. And you are right
it's very heavy on my machine (I am the only user). And if ever I put a
breakpoint on an Excel object then it means I want my PC to FREEZE.