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

[arajendren]

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.

[GregoryPERASSO]

Hello

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

regards

[arajendren]

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.

[ybagul]

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