all groups > dotnet interop > may 2005 >
You're in the

dotnet interop

group:

newbie question: c# and Excel


Re: newbie question: c# and Excel Peter Jausovec
5/27/2005 12:00:00 AM
dotnet interop:
Hi,

Did you consider using VSTO ?

Regards,
Peter Jausovec
(http://blog.jausovec.net)
[quoted text, click to view]

newbie question: c# and Excel Nolan Johnson via .NET 247
5/27/2005 8:07:27 AM
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.

--------------------------------
From: Nolan Johnson

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

Re: newbie question: c# and Excel Joe Schmoe
9/2/2005 12:47:48 PM
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. :)

[quoted text, click to view]

Re: newbie question: c# and Excel Joe Schmoe
9/2/2005 12:48:58 PM
Or am I just going about it the wrong way?

[quoted text, click to view]

AddThis Social Bookmark Button