473,385 Members | 1,343 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

MS Office and .NET framework

Helllo,

is there a version of Microsoft Office, where you can link .NET Dll's (
assemblies ) with it, instead of COM Dll's? If not, does anybody know when
there will be?

Thank you for any info,

Me.
Jul 21 '05 #1
4 1592
There is no version of Office at present that exposes a .Net interface to
its object model, but Microsoft has primary interop assemblies available for
calling Office objects via COM from .Net. But unfortunately it has to go
thru the COM Interop and the marshalling can be painfully slow if you are
transferring large amounts of data.

In our project we have basically implemented an Excel XLA addin to help make
the communication with .Net "chunky" rather than "chatty" so that the
performance hit is kept to a minimum. There are numerous articles on
designing of "chunky" vs "chatty" interfaces to help with the COM interop
issues on MSDN.

If I had to guess, I would say that a version of office that is pure .Net is
still a good distance away, but I'm really really hoping that Microsoft
releases an interface that does a much more efficient job marshalling the
data.
"Elephant" <el******@microsoft.com> wrote in message
news:TJ********************@casema.nl...
Helllo,

is there a version of Microsoft Office, where you can link .NET Dll's (
assemblies ) with it, instead of COM Dll's? If not, does anybody know when
there will be?

Thank you for any info,

Me.

Jul 21 '05 #2
Bryan wrote:
There is no version of Office at present that exposes a .Net interface to
its object model,


??

What's the score with Office 2003? What is the "official" way to program
it, surely it can't be VBA??

--
Gerry Hickman (London UK)
Jul 21 '05 #3

"Gerry Hickman" <ge********@yahoo.co.uk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Bryan wrote:
There is no version of Office at present that exposes a .Net interface to
its object model,
??

What's the score with Office 2003? What is the "official" way to program
it, surely it can't be VBA??


You can code it with VBA, or thru external automation - but all the
interfaces are still COM. The only way to code it thru .Net is to use the
interop.

Bryan

--
Gerry Hickman (London UK)

Jul 21 '05 #4
Bryan wrote:
What's the score with Office 2003? What is the "official" way to program
it, surely it can't be VBA??


You can code it with VBA, or thru external automation - but all the
interfaces are still COM. The only way to code it thru .Net is to use the
interop.


Doesn't exactly inspire confidence if Microsoft's flagship product does
not directly support .NET

Was there not something called VSA that was going to enable office apps
to work direct with .NET?

--
Gerry Hickman (London UK)
Jul 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jason | last post by:
Hi, I have managed to automate the inclusion of the framework and SP into my installs but have hit a brick wall on being able to switch on the Programmabilty support for office applications...
3
by: | last post by:
Hi! How to extand and access the internat Office object structure. Is there any Dev Kit for Microsoft Partners that in not available to "normal" users? Something like NOKIA back entrence!? ...
4
by: J-T | last post by:
I'm trying to read an excell file in my .Net application using Office XP Primary Interop Assemblies (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp)....
0
by: Howard Kaikow | last post by:
I have a multiboot system. On one of the systems, I have Office 2002, VS .NET Pro 2002 and the Office 2002 PIA with .NET Framework 1.0. On another system, I have Office 2003, VS .NET Pro 2003...
3
by: Jason | last post by:
Hi, I have managed to automate the inclusion of the framework and SP into my installs but have hit a brick wall on being able to switch on the Programmabilty support for office applications...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.