Using Excel functions in C#???

[osmarjunior]

Is it possible to use an Excel function inside C# code?

Regards.

Junior.

 

[sloan]

You can either import the Excel Library ... (like you would a COM object)
Or you can work with xml.. in an "excel flavor". (not trivial).


You can see a little bit of both at my article:

http://www.sqlservercentral.com/columnists/sholliday/

(Leveraging XP Excel , XML, and OPENXML for Data Imports)

 

[osmarjunior]

Thanks. And both of these solutions I can use without have the MS Excel
installed on the user machines???

Regards.

Junior.

 

[Willy Denoyette [MVP]]

No, you can't use Excel functions without having excel installed, nor is xml
of any help here.

Willy.

|
| Thanks. And both of these solutions I can use without have the MS Excel
| installed on the user machines???
|
| Regards.
|
| Junior.
|
| sloan wrote:
| > You can either import the Excel Library ... (like you would a COM
object)
| > Or you can work with xml.. in an "excel flavor". (not trivial).
| >
| >
| > You can see a little bit of both at my article:
| >
| > http://www.sqlservercentral.com/columnists/sholliday/
| >
| > (Leveraging XP Excel , XML, and OPENXML for Data Imports)
| >
| >
| >
| > | > > Is it possible to use an Excel function inside C# code?
| > >
| > > Regards.
| > >
| > > Junior.
| > >
|