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...
"Clive" <cl***@nospam.com> wrote in message
news:03****************************@phx.gbl...

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.

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

--
I hope this helps,
Steve C. Orr, MCSD
http://Steve.Orr.net
"abacnet" <ab*****@hotmail.com> wrote in message
news:e%***************@TK2MSFTNGP12.phx.gbl...

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...
"Clive" <cl***@nospam.com> wrote in message
news:03****************************@phx.gbl...

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]

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.

"Steve C. Orr, MCSD" <St***@Orr.net> wrote in message
news:uA**************@TK2MSFTNGP12.phx.gbl...

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.

--
I hope this helps,
Steve C. Orr, MCSD
http://Steve.Orr.net
"abacnet" <ab*****@hotmail.com> wrote in message
news:e%***************@TK2MSFTNGP12.phx.gbl...

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...
"Clive" <cl***@nospam.com> wrote in message
news:03****************************@phx.gbl...

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.