Skip to main content
A
arajendren9-Granite
9-Granite
June 3, 2015
Question

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

  • June 3, 2015
  • 3 replies
  • 2086 views

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

GregoryPERASSO
GregoryPERASSO16-Pearl
16-Pearl
June 3, 2015

Hello

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

regards

A
arajendren9-GraniteAuthor
9-Granite
June 3, 2015

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.

Y
ybagul1-Visitor
1-Visitor
June 3, 2015

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

Terms & ConditionsAccessibility statement