cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Need API to launch excel,connect to windchill and update document

Newbie

Need API to launch excel,connect to windchill and update document

Hi,

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.

Thanks.

3 REPLIES 3

Re: Need API to launch excel,connect to windchill and update document

Hello

there's the DTI "DEsktop integration" module that allow to do that OOTB from office applications

regards

Re: Need API to launch excel,connect to windchill and update document

Hi Perasso.

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.

Thanks.

Re: Need API to launch excel,connect to windchill and update document

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.

Re: How to call Windchill API from outside the Windchill

Announcements
LiveWorx Call For Papers Happening Now!