newbie question: c# and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nolan Johnson - 27 May 2005 16:07 GMT

Newbie question. I see lots of details about how to use COM to create and manipulate Excel objects from c# here and elsewhere on the web.

We're going to re-work a VBA application that we have that does some complex manipulations of Excel files, and one thing that we're considering is c# or VB and COM rather than VBA.

The question is this: can I do absolutely everything in c#/COM that I could do in VBA? Or are there limitations? I want to make sure that I won't lose any functionality before committing to any particular toolset.

Thanks.

Reply to this Message

Peter Jausovec - 27 May 2005 16:51 GMT

Hi,

Did you consider using VSTO ?

Regards,
Peter Jausovec
(http://blog.jausovec.net)

> Newbie question. I see lots of details about how to use COM to create and
> manipulate Excel objects from c# here and elsewhere on the web.
[quoted text clipped - 16 lines]
>
> <Id>R0uaKKbxYUmref8NQMAjAA==</Id>

Reply to this Message

Joe Schmoe - 02 Sep 2005 18:47 GMT

What does that get anyone? Took a quick look and it looks like it's still
just a bunch of slow Interop calls, possibly made slower because VSTO just
wraps the Interop calls. Just really didn't get the point of using VSTO.

I'd like to find a pure .NET way of generating Excel (or other Office)
files. Interop is too slow when doing things that will need thousands of
calls.

Please educate me if you know. :)

> Hi,
>
[quoted text clipped - 23 lines]
>>
>> <Id>R0uaKKbxYUmref8NQMAjAA==</Id>

Reply to this Message

Joe Schmoe - 02 Sep 2005 18:48 GMT

Or am I just going about it the wrong way?

> What does that get anyone? Took a quick look and it looks like it's still
> just a bunch of slow Interop calls, possibly made slower because VSTO just
[quoted text clipped - 34 lines]
>>>
>>> <Id>R0uaKKbxYUmref8NQMAjAA==</Id>

Reply to this Message

Rate this thread:

newbie question: c# and Excel

Free Magazines