objExcel = CreateObject("Excel.Application") in c#

Question

How to convert objExcel = CreateObject( its in vb..how it will be used in c#? 'Excel.Application' ) this line to c#

Sam Hobbs · Answer

I assume the VB code is not VB .Net code. The VB code would be different for VB .Net and it would be more relevant for use in C# too. I think that CreateObject will create an unmanaged COM object, whereas for .Net it is better to use .NET Framework assemblies. You can do that by adding the relevant Excel and Office references. There are many articles in this web site about that. I show a sample in Problem with Exporting data into Excel using C# but please also look at the articles in this web site.

Vulpes · Answer

If you need to create a late bound object, then I'd try this: Type t = Type.GetTypeFromProgID("Excel.Application"); object objExcel = System.Activator.CreateInstance(t); Alternatively, you can add a reference to Microsoft.VisualBasic.dll to your C# application and then add this using directive: using Interaction = Microsoft.VisualBasic.Interaction; You can then call CreateObject directly as follows: object objExcel = Interaction.CreateObject("Excel.Application");

objExcel = CreateObject("Excel.Application") in c#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)