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" <os*********@gmail.com> wrote in message
news:11*********************@d56g2000cwd.googlegro ups.com...

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

Regards.

Junior.

[osmarjunior]

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)

"osmarjunior" <os*********@gmail.comwrote in message
news:11*********************@d56g2000cwd.googlegro ups.com...

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

Regards.

Junior.

[eran_aharonovich]

If you use Excel.Application then you'd have to install Office Excel.

Each time you create Excel Application object you actually open EXCEL - you can check the task manager yourself.


Microsoft released a package called "Microsoft office web components" which does not require you to install Excel.

Check it out.

Microsoft Office Web Components


Eran Aharonovich
www.Noviway.com

[eran_aharonovich]

You can try this:

Install the last microsoft office web components.

Add reference to "Microsoft Office Web Componenets".

And use this code:


Microsoft.Office.Interop.Owc11.SpreadsheetClass ws = new Microsoft.Office.Interop.Owc11.SpreadsheetClass();

ws.get_Range("B1","B1").Value2 = 1;
ws.get_Range("B2", "B2").Value2 = 2;
ws.get_Range("B3", "B2").Value2 = 3;

ws.get_Range("A1", "A1").Formula = "=SUM(B1:B3)";
double value = (double)ws.get_Range("A1", "A1").Value2;


Eran Aharonovich
www.Noviway.com

[Willy Denoyette [MVP]]

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

Willy.

"osmarjunior" <os*********@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
|
| 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)
| >
| >
| >
| "osmarjunior" <os*********@gmail.comwrote in message
| news:11*********************@d56g2000cwd.googlegro ups.com...
| Is it possible to use an Excel function inside C# code?
|
| Regards.
|
| Junior.
|
|