How to work with excel application

[ialscorp]

could anyone give some example in VB.NET how to connect to excel ,work there and return back to nx....

 

[basenxuser]

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.