Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to work with excel application

Status
Not open for further replies.

ialscorp

Automotive
Aug 31, 2007
20
0
0
RU
could anyone give some example in VB.NET how to connect to excel ,work there and return back to nx....
 
Replies continue below

Recommended for you



Hi,

Its needs a bit more than journaling knowledge.
Reading Excel can be achieved simpy using "OleDbConnection" and "OleDbDataAdapter". [Check MSDN for further assistance]

Writing Excel needs the instances of EXcel application classes.

To achieve aforesaid both Excel and MS office core interoperables should be referenced in your application( exe/dll) to gain access to these classes.

 
Status
Not open for further replies.
Back
Top