My requirement is I need to launch Excel,connect to Windchill from excel ,search and open a document,check-out and check-in,all from excel.
Have anyone worked on similar scenario.
Please let me know what is the API used for this.
there's the DTI "DEsktop integration" module that allow to do that OOTB from office applications
Thanks for the answer.
Actually I am using DTI module to update the excel template with mapped IBA values.
Later using this template,I need to create document and update the mapped IBAs in document with new values.This creation of document and updating IBAs in document needs to be done using API in background.I am able to achieve these except that IBAs are not refreshing with new values in excel.
Hence I need an API which can launch excel ,search for document and open and check-in.
You can write a macro in Excel which calls a web service (IE Task) with Document Number. This IE Task in turns calls a custom Java class. Then search and check out document, update IBA and checkin with Java code.
Check following post for more help.