How to work with excel application
How to work with excel application
(OP)
could anyone give some example in VB.NET how to connect to excel ,work there and return back to nx....
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
How to work with excel application
|
RE: How to work with excel application
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.